[Digikam-devel] [Bug 191494] Wish: search offline collections (e.g. removable medias)

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=191494





--- Comment #22 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-05-30 14:07:41 ---
@ Mikolaj: Calculating for 100,000 is ok. I do tests with 30,000 because I dont
have more. If you open a database file I assume not all of this is loaded into
memory! That would not work at all.

So the question here is: What is the most efficient storage for 10,000s of
files of the size 10k-30k. The offered solutions are:
a) in filesystem, assumed standard Linux ext3/ext4
b) as BLOBs in sqlite

I have done some superficial research, came up with these pages:
http://stackoverflow.com/questions/757493/sqlite-blob-or-file-system-for-images
http://stackoverflow.com/questions/325126/storing-a-small-number-of-images-blob-or-fs
http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay

all of this is from the web development field and has some different
priorities, I did not really get a clear answer.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.