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: What are the least SQL intensive Index Page Blocks?  (Read 4979 times)

0 Members and 1 Guest are viewing this topic.

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
What are the least SQL intensive Index Page Blocks?
« on: January 26, 2019, 05:57:45 pm »
I run many large photo galleries that have many visitors. I am trying to improve the performance by following the documentation: http://documentation.coppermine-gallery.net/en/performance.htm

Can anyone provide any insight on what "index blocks" cause the least amount of SQL lookups and is more efficient to use?

The performance page specifically lists "last uploaded", "last updated album" and "random" as intensive on large galleries. I would assume "last viewed" is just as intensive.

A cache plugin to avoid these SQL queries would be nice.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
What are the least SQL intensive Index Page Blocks?
« Reply #1 on: March 14, 2019, 09:43:55 pm »
Quote from: idosha on January 26, 2019, 05:57:45 pm
A cache plugin to avoid these SQL queries would be nice.

There will be a cache plugin for cpg1.6.x:
Quote from: ron4mac on January 27, 2019, 02:25:01 pm
Some form of caching, however, is a very good idea and will be considered for a future release of CPG.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.026 seconds with 19 queries.