forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: antisa33 on February 03, 2006, 01:01:58 am

Title: 12000 picts : slow search query
Post by: antisa33 on February 03, 2006, 01:01:58 am

Hello, in cpg_picures i have 12000 pictures.
 i can see on my server than in search.php, the query is very slow because the search.php must look in 12000 lines, and give juste a few result.
How can i optimize this ? Is it possible ?
Thank you for all  :D :D

Title: Re: 12000 picts : slow search query
Post by: Stramm on February 04, 2006, 02:37:54 pm

The more complex your search is the longer it'll need. If you just search in the indexes (title, caption, keywords, filename) it should be pretty fast. Do you have a link so that I can have a look?