Advanced search  

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

Pages: [1]   Go Down

Author Topic: 12000 picts : slow search query  (Read 2367 times)

0 Members and 1 Guest are viewing this topic.

antisa33

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 181
    • Free french kids coloring
12000 picts : slow search query
« 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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: 12000 picts : slow search query
« Reply #1 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?
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.