[KPhotoAlbum] 45 000 images & KPhotoAlbum speed on Athlon 1GHz

Risto H. Kurppa risto at kurppa.fi
Mon Jan 30 22:06:55 GMT 2006


Hi!

Just to let you know what happens with a large database..

I finally managed to load (ie. I was able to track the damaged jpegs)
my photo collection into KimDaBa (using kimdaba-2006-01-14-noi18n ).

Sometimes it's very fast and does right away what I'm asking it to do
(a search, show thumbnails, whatever). But sometimes (with no other
resource monster programs running) it gets 'stuck'. It starts to work
on something and doesn't respond to anything. I see that it's reading
or writing (reading, I hope..) the hard drive. Usually the program
takes some 370 (VM) + 200 (PM) Mb of memory - but it's been up to 700
+ something.. But it'll eventually start working, if I'll just let it
work (over the night, for example..) long enoug.

At least saving makes it stuck for a while.. Never actually measured
it precisely but I'd guess up to an hour or something

Database size is about 21 Mb ( not compressed).
Processor is Athlon 1GHz

Then some actual questions:
-Does anyone else have similar problems with large (how large?) database?

-What'll the 'convert backend (experimental)..' or similar menu option do..?
Have I understood correctly that it'll start using sqlite database
instead of the xml database file or will it use both? Would this make
it faster - and how do you get the information from the database in
case you need it WITHOUT KPhotoAlbum/KimDaBa (reading a XML file is
simple with any programming language - how's it with a sqlite
database..? XML is one of the main reasons I chose KimDaBa)

-Where has the 'search folders' search pane disappeared?
On the last official (not snapshot) KimDaBa release it was possible to
select folders you wanted to search in - but not anymore. Will this
ever be back, what's the reason to remove it? It was easy to tag
images in specific folders with some reasonable folder names (I mean
images in folders Holiday2002, Holiday2003, Holiday2004 could all be
tagged as 'holiday' by searching for the images in all holiday -
folders..)


Thank's Jesper 'Green Xtra Hot Chili Pepper' for a great program & work!


risto




More information about the Kphotoalbum mailing list