Advanced search  

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]

Pages: [1]   Go Down

Author Topic: What are the least SQL intensive Index Page Blocks?  (Read 103 times)

0 Members and 1 Guest are viewing this topic.

idosha

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
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
Pages: [1]   Go Up
 

Page created in 0.013 seconds with 20 queries.