Print

[user454]

Hello.
My gallery - 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 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:

Code: [Select]

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.

[user454]

I found problem - it is keywords.
I use this Andre's solution: http://forum.coppermine-gallery.net/index.php/topic,75801.msg365602.html#msg365602
I add

Code: [Select]

include('include/keyword.inc.php'); and index.php load about 3-5 sec.
I removed it - and gallery load instantly.