forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: doublezeroracing on August 13, 2004, 08:22:16 am

Title: index.php very slow to load...
Post by: doublezeroracing 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.

Title: Re: index.php very slow to load...
Post by: doublezeroracing 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.

Title: Re: index.php very slow to load...
Post by: omniscientdeveloper 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

Title: Re: index.php very slow to load...
Post by: doublezeroracing 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.

Title: Re: index.php very slow to load...
Post by: Joachim Müller 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

Title: Re: index.php very slow to load...
Post by: doublezeroracing 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.