Hello.
My gallery - daitepak.com (http://daitepak.com)
My problem - main page is loading from 5 to 15 seconds, but other pages work really fast (1-3s).
(I attach screenshot with test).
I read thread http://forum.coppermine-gallery.net/index.php/topic,76466.0.html (http://forum.coppermine-gallery.net/index.php/topic,76466.0.html) below, i tried to edit index.php and everything else that is mentioned there, and it dont help.
I enable debug information for all user.
From debug i found this:
SELECT p.*, r.title
FROM cpg15x_pictures AS p
INNER JOIN cpg15x_albums AS r ON r.aid = p.aid
WHERE (1)
AND approved = 'YES'
GROUP BY p.aid
HAVING COUNT(p.pid) > 0
ORDER BY r.alb_hits ASC
LIMIT 0 ,24 [plugins/more_meta_albums/codebase.php:370] (2767.3 ms)
Query is 2767.3 ms, but not always. usually it takes a minimum time to execute.
I tried disabling all extensions including this, but the download speed is not much affected.
Please help me fix it.
I found problem - it is keywords.
I use this Andre's solution: http://forum.coppermine-gallery.net/index.php/topic,75801.msg365602.html#msg365602 (http://forum.coppermine-gallery.net/index.php/topic,75801.msg365602.html#msg365602)
I add include('include/keyword.inc.php'); and index.php load about 3-5 sec.
I removed it - and gallery load instantly.