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: Index.php loaded very long time  (Read 2301 times)

0 Members and 1 Guest are viewing this topic.

user454

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Index.php loaded very long time
« on: August 04, 2013, 06:13:47 pm »

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.
Logged

user454

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: Index.php loaded very long time
« Reply #1 on: August 13, 2013, 09:31:28 pm »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.