12000 picts : slow search query 12000 picts : slow search query
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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.

Print
Go Down Pages1
User actions

antisa33

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

Stramm

#1
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?
Print
Go Up Pages1
User actions