Gallery is so slow

Alanmelon

Newbie

Offline

Posts: 7

Gallery is so slow

« on: March 30, 2007, 01:04:21 pm »

I have an installation of SMF Gallery Pro on my site with a large number of categories and images which I have taken the time to import from existing folders. I noticed that while adding these categories, the more I added, the slower the site would become to add each subsequent category. If I now wish to edit or move any exisiting category it takes forever to carry out the request. The gallery is also slow to browse. I guess the obvious answer would be that I've added too many images and categories for this code to cope with but I didn't expect this to be the case.

Is there any modification or adjustment I can make to help with this problem?

URL: http://www.shoppingtvbabes.co.uk


« Last Edit: March 30, 2007, 02:59:37 pm by Alanmelon »	Logged

SMFHacks

Administrator
Hero Member

Offline

Posts: 9680

Re: Gallery is so slow

« Reply #1 on: March 30, 2007, 06:58:47 pm »

Hmm, it should not be that slow.

Can you add the following code to your settings.php file
$db_show_debug = true;

Then click on the "Queries used" link near the bottom and and get the list of the quieres and time they took.


	Logged

Alanmelon

Newbie

Offline

Posts: 7

Re: Gallery is so slow

« Reply #2 on: March 31, 2007, 01:15:38 pm »

Here are the queries used.

http://www.shoppingtvbabes.co.uk/queries1.txt

http://www.shoppingtvbabes.co.uk/queries2.txt

queries1 shows those on loading the gallery index (top level)

queries2 shows those on trying to reorder a category (warning - LONG list!)


« Last Edit: March 31, 2007, 01:46:18 pm by Alanmelon »	Logged

RWL

Full Member

Offline

Posts: 100

Re: Gallery is so slow

« Reply #3 on: March 31, 2007, 01:27:42 pm »

Hi Alan.

The gallery is very quick for me on a standard broadbannd connection?

Regards,

Wilsy.


	Logged

RewindLancs.com Management

SMFHacks

Administrator
Hero Member

Offline

Posts: 9680

Re: Gallery is so slow

« Reply #4 on: March 31, 2007, 01:37:52 pm »

I would disable "Count child categories" for now.
I have an idea how I can improve the speed of picture count totals.

Also don't forget to upgrade to the customer group via the license button to get access to more forums and mods for the Gallery.


	Logged

Pages: [1]

« previous next »