close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Gallery pages very slow to open

Thread began 3/22/2011 10:57 am by kbettenc296716 | Last modified 3/24/2011 4:08 pm by Jason Byrnes | 1267 views | 3 replies |

kbettenc296716

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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:

php:
CREATE INDEX gallery_id ON pg1_gallery_images (gallery_id)
Sign in to reply to this post

kbettenc296716

Gallery slow

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...