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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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?