Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Slooow Loading Site


Guest

Recommended Posts

Sorry if you are reading this as a duplicate... I posted it to the wrong board

 

I developed this site

 

www.ambassadorpressllc.com. It only has 3 products loaded at this time. I have the thumbnail contribution installed and it is working alright. The site, however, is taking forever to load, even on pages like contact.php which have no images.

 

The server is hosting other osCommerce sites that I've developed which are running fine. I double checked configure.php against my other working sites and everything matches up. The part of the site that isn't inside of osCommerce loads adequately.

 

So I've nailed down what it isn't... it's not the server, it's not the database, it's not the configure.php file. Does anyone have any ideas? The site worked before and nothing has been changed.

 

Thanks,

 

Tina Boyd

Link to comment
Share on other sites

It sure loads sloooooooooow.

 

But when it finally loaded an ssl certificate error popped up. So I checked the <base href="http://ambassadorpressllc.com/bookstore/"> which is fine.

 

but the images are loading from <img src="https://secure16.websitewelcome.com/~ambassad/bookstore/images/

 

So you goofed somewhere, probably in the config file.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

I'll add:

 

I opened one of the product images on the front page and even though it's a reasonably small size it took forever to load.

 

Your image source is definitely your problem.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

I'll add:

 

I opened one of the product images on the front page and even though it's a reasonably small size it took forever to load.

 

Your image source is definitely your problem.

 

The href's on the header tags are absolute urls, but the header is loading quickly. The images within the page are at the correct url. Since the problem is occuring throughout the osCommerce portion of the site, even on pages without images, I really don't think it's an image problem.

 

Any other ideas?

 

Tina

Who is sorry for posting her link under her name

Link to comment
Share on other sites

The href's on the header tags are absolute urls, but the header is loading quickly. The images within the page are at the correct url. Since the problem is occuring throughout the osCommerce portion of the site, even on pages without images, I really don't think it's an image problem.

 

Any other ideas?

 

Tina

Who is sorry for posting her link under her name

Try enabling logging on osCommerce to see which requests are taking the longest.

Dont forget to Search. Your problem has already been fixed before.<br>

Please visit Manchester-Fireworks.com.

Link to comment
Share on other sites

Try enabling logging on osCommerce to see which requests are taking the longest.

Well, I enabled logging, but my log file (If I set it up properly) is only showing one line after the page completely loads

 

08/07/2005 07:35:37 [0.046s] /bookstore/admin/configuration.php?gID=10&cID=119&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

 

And I have no idea what it means?

 

Thoughts?

 

Tina

Link to comment
Share on other sites

Well, I enabled logging, but my log file (If I set it up properly) is only showing one line after the page completely loads

 

08/07/2005 07:35:37 [0.046s] /bookstore/admin/configuration.php?gID=10&cID=119&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

 

And I have no idea what it means?

 

Thoughts?

 

Tina

Turn on the sql query logging, that will give you a better understanding of whats going on inside osCommerce.

Dont forget to Search. Your problem has already been fixed before.<br>

Please visit Manchester-Fireworks.com.

Link to comment
Share on other sites

Turn on the sql query logging, that will give you a better understanding of whats going on inside osCommerce.

 

I don't know where to do that.

 

I do have better results now though, but I don't know what they mean

 

08/07/2005 07:35:37 [0.046s] /bookstore/admin/configuration.php?gID=10&cID=119&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:42:19 [0.046s] /bookstore/admin/configuration.php?gID=10&cID=122&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:42:20 [0.077s] /bookstore/admin/configuration.php?gID=10&cID=122&action=edit&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:42:22 [0.071s] /bookstore/admin/configuration.php?gID=10&cID=122&action=save&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:42:22 [QUERY] select value from sessions where sesskey = '0ad5843ef4ff3161fc487f5a741a1808' and expiry > '1120826542'

08/07/2005 07:42:22 [QUERY] select configuration_group_title from configuration_group where configuration_group_id = '10'

08/07/2005 07:42:22 [QUERY] select configuration_group_id as cgID, configuration_group_title as cgTitle from configuration_group where visible = '1' order by sort_order

08/07/2005 07:42:22 [QUERY] select configuration_id, configuration_title, configuration_value, use_function from configuration where configuration_group_id = '10' order by sort_order

08/07/2005 07:42:22 [QUERY] select configuration_key, configuration_description, date_added, last_modified, use_function, set_function from configuration where configuration_id = '122'

08/07/2005 07:42:22 [0.047s] /bookstore/admin/configuration.php?gID=10&cID=122&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:42:58 [QUERY] select value from sessions where sesskey = '0ad5843ef4ff3161fc487f5a741a1808' and expiry > '1120826578'

08/07/2005 07:42:58 [QUERY] select configuration_group_title from configuration_group where configuration_group_id = '10'

08/07/2005 07:42:58 [QUERY] select configuration_group_id as cgID, configuration_group_title as cgTitle from configuration_group where visible = '1' order by sort_order

08/07/2005 07:42:58 [QUERY] select configuration_id, configuration_title, configuration_value, use_function from configuration where configuration_group_id = '10' order by sort_order

08/07/2005 07:42:58 [QUERY] select configuration_key, configuration_description, date_added, last_modified, use_function, set_function from configuration where configuration_id = '122'

08/07/2005 07:42:58 [0.044s] /bookstore/admin/configuration.php?gID=10&cID=122&action=edit&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:43:00 [QUERY] select value from sessions where sesskey = '0ad5843ef4ff3161fc487f5a741a1808' and expiry > '1120826580'

08/07/2005 07:43:00 [QUERY] update configuration set configuration_value = 'false', last_modified = now() where configuration_id = '122'

08/07/2005 07:43:00 [0.039s] /bookstore/admin/configuration.php?gID=10&cID=122&action=save&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

08/07/2005 07:43:00 [0.046s] /bookstore/admin/configuration.php?gID=10&cID=122&osCAdminID=0ad5843ef4ff3161fc487f5a741a1808

Link to comment
Share on other sites

The images within the page are at the correct url.

Any other ideas?

 

Tina

Who is sorry for posting her link under her name

 

This is the url I get for the right hand image of the three product images on the front page, I put the lline break in after php? so as not to stretch the margins.

 

 

http://ambassadorpressllc.com/bookstore/product_thumb.php?

img=https://secure16.websitewelcome.com/~ambassad/bookstore/images/stone-upon-stone.gif&w=150&h=110

 

I'd track down and fix the obvious errors before I started doing more complex things like sql query logging.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Just look at the page source. HTTPS references for images are all over the place.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

I performed a wget of the main index page and it took 1min 20 seconds just to download the HTML. This is not caused by the image issue. Its a pure HTML generation time issue.

 

There has to be one or two sql statements taking too long when generating the page.

 

me@myserver [/tmp]# time wget http://www.ambassadorpressllc.com/bookstore

? ?  --14:21:26--? http://www.ambassadorpressllc.com/bookstore

? ? ? ? ?  => `bookstore'

Resolving www.ambassadorpressllc.com... done.

Connecting to www.ambassadorpressllc.com[67.19.156.130]:80... connected.

HTTP request sent, awaiting response... 301 Moved Permanently

Location: http://www.ambassadorpressllc.com/bookstore/ [following]

--14:21:26--? http://www.ambassadorpressllc.com/bookstore/

? ? ? ? ?  => `index.html'

Connecting to www.ambassadorpressllc.com[67.19.156.130]:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: unspecified [text/html]

 

? ? [? <=>? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ] 11,249? ? ? ? 49.71K/s

 

14:22:47 (49.71 KB/s) - `index.html' saved [11249]

 

 

real? ? 1m20.617s

user? ? 0m0.040s

sys? ?  0m0.010s

Dont forget to Search. Your problem has already been fixed before.<br>

Please visit Manchester-Fireworks.com.

Link to comment
Share on other sites

it's not the server, it's not the database, it's not the configure.php file

 

Despite what you say there is definitely something wrong if your images are being pulled from a shared ssl address. I have a 2 Gb connection here and I can't even get your website to load at all!

 

Save these good folks some time and post your includes/configure.php file here (minus db user name and password) and we can then at least eliminate that possibility.

 

Vger

Link to comment
Share on other sites

I have a 2 Gb connection here and I can't even get your website to load at all!

 

Vger

 

Just open the site in another window, go tend to other tasks, then after a minute or so the page will come up preceded by ssl certificate errors.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Finally managed to get your page loaded. The flash images won't help on loading time, and are totally unnecessary as the same effect could have been achieved with rollovers. Also getting the security certificate warning the same as others have seen.

 

Also, upon entering the site I am logged in, and even if I follow the log out link I remain logged in.

 

Vger

Link to comment
Share on other sites

I performed a wget of the main index page and it took 1min 20 seconds just to download the HTML.  This is not caused by the image issue. Its a pure HTML generation time issue.

 

 

Look at the line I posted above. She's feeding the thumbnailer routine an external url to a shared ssl image.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Why would the fact that the images are on an SSL site and the banner is flash affect the download of the index page with wget. wget only performs a fetch of the HTML page and not the images \ objects contained in it. The slow performance must be being caused by something in the backend.

 

I agree that if the images are configured worng then something else could be but as the page is being generated correctly it does not seem like there is.

 

Rgds

 

S

Dont forget to Search. Your problem has already been fixed before.<br>

Please visit Manchester-Fireworks.com.

Link to comment
Share on other sites

The site worked before and nothing has been changed.

 

Maybe I'm getting to be too cynical, but the number of posts that have said that and had people running around in circles trying to sort out a problem - only to find that something was changed which messed the whole site up.

 

Good luck folks!

 

Vger

Link to comment
Share on other sites

Why would the fact that the images are on an SSL site and the banner is flash affect the download of the index page with wget.  wget only performs a fetch of the HTML page and not the images \ objects contained in it.  The slow performance must be being caused by something in the backend.

 

 

I see,

 

You're the kind of guy driving down the road with the gas gauge below E. When the car sputters to a stop you decide to take out the spark plugs and figure out what's going on.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Golly Neds guys! I didn't mean to start an agrument.

 

Here is the config file

 

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://ambassadorpressllc.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', 'https://secure16.websitewelcome.com/~ambassad'); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', true); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'ambassadorpressllc.com');
 define('HTTPS_COOKIE_DOMAIN', 'secure16.websitewelcome.com/~ambassad');
 define('HTTP_COOKIE_PATH', '/bookstore/');
 define('HTTPS_COOKIE_PATH', '/bookstore/');
 define('DIR_WS_HTTP_CATALOG', '/bookstore/');
 define('DIR_WS_HTTPS_CATALOG', '/bookstore/');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', '/home/ambassad/public_html/bookstore/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

Link to comment
Share on other sites

I see,

 

You're the kind of guy driving down the road with the gas gauge below E. When the car sputters to a stop you decide to take out the spark plugs and figure out what's going on.

You mean the guage goes above E? :huh:

 

<suck eggs>

To be serious, the initial respose to a web request is to download the index page (or default in M$ talk). This then tells the browser what it needs to display the entire page such as gfx's and flash objects.

</suck eggs>

 

It is taking around 1minute 20 seconds to download the index page, now is it just me or does that point to a problem?

 

Download of my website from another location

me@myserver[/tmp]# time wget http://www.gadgitech.co.uk/

--15:14:52--? http://www.gadgitech.co.uk/

? ? ? ? ?  => `index.html'

Resolving www.gadgitech.co.uk... done.

Connecting to www.gadgitech.co.uk[81.3.86.114]:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: unspecified [text/html]

 

? ? [? <=>? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ] 42,500? ? ?  194.85K/s

 

15:14:52 (194.85 KB/s) - `index.html' saved [42500]

 

 

real? ? 0m0.495s

user? ? 0m0.020s

sys? ?  0m0.020s

 

Download of www.ambassadorpressllc.com from same location

me@myserver [/tmp]# time wget http://www.ambassadorpressllc.com/bookstore/

--15:19:24--? http://www.ambassadorpressllc.com/bookstore/

? ? ? ? ?  => `index.html'

Resolving www.ambassadorpressllc.com... done.

Connecting to www.ambassadorpressllc.com[67.19.156.130]:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: unspecified [text/html]

 

? ? [? <=>? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ] 11,249? ? ? ? 49.04K/s

 

15:20:51 (49.04 KB/s) - `index.html' saved [11249]

 

 

real? ? 1m27.025s

user? ? 0m0.020s

sys? ?  0m0.030s

 

The wget pauses at HTTP request sent, awaiting response... for 1.27, this indicates that is the amount of time it took to generate the index page and return it after the initial request. In fact the website also indicates Parse Time: 85.987s. The download time for images and other objects are not included in this figure, its pure HTML generation time.

 

Rgds

S

Dont forget to Search. Your problem has already been fixed before.<br>

Please visit Manchester-Fireworks.com.

Link to comment
Share on other sites

Maybe I'm getting to be too cynical, but the number of posts that have said that and had people running around in circles trying to sort out a problem - only to find that something was changed which messed the whole site up.

 

Good luck folks!

 

Vger

 

considering the fact that once this site launched a couple of months ago I didn't so much as visit it until my client expressed a concern regarding lack of orders i can say with all assurance that I haven't changed anything.

 

also, I can't get the sound effects the client wanted with a .gif... that's why I employed flash... but again, it worked before... it should work now.

 

Tina

Link to comment
Share on other sites

I think you should look at (or disable for now) product_thumb.php. I have no experience with it. That seems to be a real hog since it's image source is the shared ssl.

 

And turn off ssl till you get this figured out.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

I think you should look at (or disable for now) product_thumb.php. I have no experience with it. That seems to be a real hog since it's image source is the shared ssl.

 

And turn off ssl till you get this figured out.

 

Alan:

 

Turning off shared SSL sped up the page to normal... I didn't install product_thumb, but I'll address the issue with my programmer who did.

 

Thanks,

 

Tina

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...