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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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