[KPhotoAlbum] Idea for quick search feature
thsuut at utu.fi
Mon Apr 23 18:41:14 CEST 2007
On Monday 23 April 2007 18:54, Shawn Willden wrote:
> On Monday 23 April 2007 08:59, Tuomas Suutari wrote:
> > For smaller databases speed shouldn't be a problem, but making it
> > fast could be quite hard for larger databases:
> > I tested few SQL querys to implement this kind of behaviour with my
> > own DB (5544 files) and Risto's DB (43277 files).
> Is everything that can be done with indexes being done?
Nope, this was just a quick test. There is index for some of the fields
and joins, but not for every fields.
> I would think that for a KPA database it makes sense to index
> absolutely everything because it's light on insertions and heavy on
> queries, and the storage taken up by the extra indexes will be
> miniscule compared to the storage consumed by the images themselves.
Gotta try that again later with better indexing when I have more time.
(Today I'm quite busy.)
Tuomas Suutari | +358 50 3806983 | thsuut at utu.fi
More information about the KPhotoAlbum