On 20/09/10 14:58, Kent Tenney wrote: > Howdy, > > I've been looking for a home for my image collection. > > I have metadata in a .csv exported from a app I used a few > years ago, I will need to populate the new db with info on > ~60,000 files from the .csv > > Looking at photo.db, I was surprised that each tag listed the > photos, I would expect each photo to list it's tags. > > Does this scale well? > Is it expected that the photo_id_list column will contain > tens of thousands of entries?
The way they have implemented this does make sense to me. I guess that you will be wanting to regularly search by tags. By organising each tag to have the associated list of photo id's this will be much quicker than having to go through each photo and find out if it matches your tag. My current dataset is 29 000 photos, I'm currently running into trouble importing it (bug report on the way once I get something tangible to report), but am looking forward to seeing how it performs especially compared to f-spot which I'm finding very slugish. Cheers Chris _______________________________________________ Shotwell mailing list [email protected] http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
