Gallery pages very slow to open

One of my Gallery clients indicated that the navigation menu was taking forever to get to any of the gallery pages, which I found to be true. The only link that works quickly is the About page, which doesn't have a gallery on it. Right now there are 2 different menu systems being used. The assemblage.php and collage.php have WA CSS Menu writer menus, while the others have Project Seven menus. This is because I made a change to that first hoping that would improve the timing, it didn't. It takes 15 - 25 seconds from the time you click the link to get to a gallery page.

If you go to:
assemblage.php and click Portfolio/collage you will see what I mean.

This is another of my clients trying to sell her art off her website. If potential buyers cannot get to the galleries quickly, they will just give up.

I hope there is a solution. I would prefer not to have to move my clients to another ISP. I admit the one other PowerGallery client I have that uses another ISP does not have any timing problems at all. My interaction with the this ISP have not been fruitful. They, of course, say it is the software.

I hope you can find something that will help. I have not installed the newest release of PowerGallery as the last upgrade was so excruciating.

the lag seams to come from connecting to and retrieving data from the MySQL database, i get the same lag if I try access the gallery rss feed:
mediarss.php
If the problem is happening when accessing the database, not much can be done through the php coding.

you can test accessing the database by creating a blank php page in Dreamweaver and adding a recordset to it, then displaying a single record from the recordset.

If the page is still loading slowly, it is the connection between the PHP server and the mySQL server that is causing the lag.


If it is not the connection to the database, then you can try adding an index to the pg1_gallery_images table, using PHPMyQdmin or another database managemet tool, run the following query:

CREATE INDEX gallery_id ON pg1_gallery_images (gallery_id)

test.php comes up in about 3-4 seconds. So I added the index you indicated. That improved timing a little, now it is about 8-15 seconds. I don't understand the gallery_id field though. It filled it with a number which doesn't make sense to me yet. What does it mean? Can you do the original test again from your side, my WiFi is variable here at work.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.