[KPhotoAlbum] Idea for quick search feature

Tuomas Suutari thsuut at utu.fi
Mon Apr 23 17:41:14 BST 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.

I agree.

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 mailing list