Suggestion of indexes

mkochano

Joined: 2008-12-05
Posts: 27
Posted: Thu, 2012-10-18 21:25

Hi

I have added two indexes:

ALTER TABLE items ADD INDEX (relative_path_cache);
ALTER TABLE items ADD INDEX (relative_url_cache);

It reduced time of rendering an album index page (140 images) from ~34 to ~17 seconds. Gallery is quite big, 37576 rows in "items".

Maybe these indexes should be created by default?

Regards
Michał
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Thu, 2012-10-18 22:34
Quote:
Maybe these indexes should be created by default?

Good idea.
Please create a ticket: https://sourceforge.net/apps/trac/gallery/newticket and perhaps create a fork on github with your changes and it will make it into future releases faster.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team