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: index.php very slow to load...  (Read 6200 times)

0 Members and 1 Guest are viewing this topic.

doublezeroracing

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
  • Bridge City Speedway Gallery
    • Bridge City Speedway Gallery
index.php very slow to load...
« on: August 13, 2004, 08:22:16 am »

For some reason my index page is quite slow loading.  All the other pages seem to come up normally but the index seems to take an inordinate amount of time.  I've tried removing the last/random th8unbnails and the any content from it with no difference.

Any ideas?

http://gallery.doublezeroracing.com/

Thanks,

Scott.
Logged

doublezeroracing

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
  • Bridge City Speedway Gallery
    • Bridge City Speedway Gallery
Re: index.php very slow to load...
« Reply #1 on: August 14, 2004, 07:58:26 am »

Just an update...

I've noticed that the index page is only slow when no category is selected.  According to Opera the index.php loads in 6 seconds while index.php?cat=1 loads under 3.  At first I thought maybe the statistics were slowing done the page generation but I disabled them taking the same 6 seconds.

Again, thanks,

Scott.

Logged

omniscientdeveloper

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 901
Re: index.php very slow to load...
« Reply #2 on: August 14, 2004, 08:11:41 am »

Did you try removing the random section? It only loads slow the first time for me, with firefox.


-omni
Logged

doublezeroracing

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
  • Bridge City Speedway Gallery
    • Bridge City Speedway Gallery
Re: index.php very slow to load...
« Reply #3 on: August 14, 2004, 08:30:28 pm »

Makes no difference.  Since the random images are always on the index.php page it should have the same result if there's a category selected or not.

Thanks,

Scott.

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: index.php very slow to load...
« Reply #4 on: August 14, 2004, 09:20:51 pm »

turning off the random and last uploads section will not only save the time needed to load the thumbnails, but will also reduce the query time needed by mySQL. Switching off the category thumbnails will also save time.
Test this with other themes, maybe it's theme related - flushing the output buffer more frequently might help...
Switch on debug_mode in coppermine config (at the bottom to check the query load).

GauGau
Logged

doublezeroracing

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 10
  • Bridge City Speedway Gallery
    • Bridge City Speedway Gallery
Re: index.php very slow to load...
« Reply #5 on: August 17, 2004, 09:14:05 am »

Turns out there are more than double the DB queries when no category is selected.  I moved the DB onto a dedicated DB server and now all pages load under 2 seconds.

Scott.

Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.