What are the least SQL intensive Index Page Blocks? What are the least SQL intensive Index Page Blocks?
 

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

What are the least SQL intensive Index Page Blocks?

Started by idosha, January 26, 2019, 05:57:45 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

idosha

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.

Αndré

#1
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.
Print
Go Up Pages1
User actions