News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

Main Menu

12000 picts : slow search query

Started by antisa33, February 03, 2006, 01:01:58 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

antisa33

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

Stramm

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?