Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Catalog hangs up for a while when loading pages


jweltydotcom

Recommended Posts

Posted

From time to time my catalog hangs up and pauses and takes a good 15-20 seconds to finish loading the page.

 

My catalog has about 3000 products and quite a lot of categories. I've got the category counts turned off.

 

Here is more detail on what happens.. the header will load quick no problem BUT it will sometimes hang up where the bread crumb is and everything below that is just white page that has not loaded. Waiting and waiting it will eventually load the rest of the page anywhere from 15-20 seconds later. The problem doesnt happen all the time and is intermittent. i'm wondering if perhaps i need a faster server or maybe something is up with the database for the site. Currenly i'm running a Hybrid Dedicated server with load averages always less than 0.50.

 

Any help or advice on this issue would be greatly appreciated.

 

Here is a link to the site: http://www.urotuning.com/shop

Posted

Justin,

 

If you use this tool:

 

Page Load Times

 

You can see how long it takes to load each page and the page size.

 

I just timed your site, and it took 8.6 seconds to load the index.php, which is also the larges file on your site. I wouldn't say that is too bad.

 

 

 

Chris

Posted

Any help or advice on this issue would be greatly appreciated.

Start with examining the MySQL side of things. Contribution to see how many queries a page generates and how long it takes to execute them (find excessive amount of queries or slow ones) : KissER Error Handling & Debugging (needs PHP5.2 or higher).

 

Alternative: Output Queries Debug.

 

And of course you added the indexes on database tables that came with RC2a?

 

Especially the one for the table specials is helpful:

 

alter table specials add index idx_specials_products_id (products_id);

Posted

Justin,

 

If you use this tool:

 

Page Load Times

 

You can see how long it takes to load each page and the page size.

 

I just timed your site, and it took 8.6 seconds to load the index.php, which is also the larges file on your site. I wouldn't say that is too bad.

 

 

 

Chris

 

i used the tool and noticed when its loading files from "https://" that is kind of hangs up. Could that add to the load time?? i'm gonna change the way those files load on non secure pages to see if it makes any diff.

Posted

Justin,

 

If you use this tool:

 

Page Load Times

 

You can see how long it takes to load each page and the page size.

 

I just timed your site, and it took 8.6 seconds to load the index.php, which is also the larges file on your site. I wouldn't say that is too bad.

 

 

 

Chris

 

Hi,

I tested my website in your link but it said: "Processing was stopped because maximum objects size exceeded".

My website loads too slow, specially right column, where new products and offers are shown, you can check it: http://www.electriclumen.com

I removed the categories count but it still loads very slow.

Any idea?

 

Thanks.

Posted

My website loads too slow, specially right column, where new products and offers are shown, you can check it: http://www.electriclumen.com

I removed the categories count but it still loads very slow.

Ever down a "view source" of that page. It loads about 800-1000 products in the scroll box with Ofertas...

 

Strange server. If I connect to it with curl I get a 406 error. Don't know what search engines get.

 

curl -v http://www.electriclumen.com/index.php
* About to connect() to www.electriclumen.com port 80 (#0)
*   Trying 66.147.230.20... connected
* Connected to www.electriclumen.com (66.147.230.20) port 80 (#0)
> GET /index.php HTTP/1.1
> User-Agent: curl/7.19.7 (universal-apple-darwin10.0) libcurl/7.19.7 OpenSSL/0.9.8l zlib/1.2.3
> Host: www.electriclumen.com
> Accept: */*
> 
< HTTP/1.1 406 Not Acceptable
< Date: Sat, 14 Aug 2010 19:57:28 GMT
< Server: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
< Content-Length: 569
< Content-Type: text/html; charset=iso-8859-1
< 
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>406 Not Acceptable</title>
</head><body>
<h1>Not Acceptable</h1>
<p>An appropriate representation of the requested resource /index.php could not be found on this server.</p>
<p>Additionally, a 404 Not Found
error was encountered while trying to use an ErrorDocument to handle the request.</p>
<hr>
<address>Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.electriclumen.com Port 80</address>
</body></html>

Posted

Ever down a "view source" of that page. It loads about 800-1000 products in the scroll box with Ofertas...

 

Strange server. If I connect to it with curl I get a 406 error. Don't know what search engines get.

 

curl -v http://www.electriclumen.com/index.php
* About to connect() to www.electriclumen.com port 80 (#0)
*   Trying 66.147.230.20... connected
* Connected to www.electriclumen.com (66.147.230.20) port 80 (#0)
> GET /index.php HTTP/1.1
> User-Agent: curl/7.19.7 (universal-apple-darwin10.0) libcurl/7.19.7 OpenSSL/0.9.8l zlib/1.2.3
> Host: www.electriclumen.com
> Accept: */*
> 
< HTTP/1.1 406 Not Acceptable
< Date: Sat, 14 Aug 2010 19:57:28 GMT
< Server: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
< Content-Length: 569
< Content-Type: text/html; charset=iso-8859-1
< 
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>406 Not Acceptable</title>
</head><body>
<h1>Not Acceptable</h1>
<p>An appropriate representation of the requested resource /index.php could not be found on this server.</p>
<p>Additionally, a 404 Not Found
error was encountered while trying to use an ErrorDocument to handle the request.</p>
<hr>
<address>Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.electriclumen.com Port 80</address>
</body></html>

 

Hello,

I'm so sorry but I don't know what you want to explain me.

We've hired a technician for operation of website. I only upload images, descriptions, translations... I don't understand about servers or specific computer terms.

There are 1644 proucts in the catalog.

I'm sorry but I don't understand about computers and I don't speak English.

Thanks.

Posted

I'm so sorry but I don't know what you want to explain me.

We've hired a technician for operation of website. I only upload images, descriptions, translations... I don't understand about servers or specific computer terms.

There are 1644 proucts in the catalog.

I'm sorry but I don't understand about computers and I don't speak English.

So what you are telling us is that you are asking questions here but cannot do anything with the answers. What's the point of answering your question then? :)

Posted

Esther,

 

I appears you have scrolling specials on the website. And, you have 1370 specials loaded. That is why your site is loading very slowly. The scrolling specials box was not designed to handle that many specials at one time. So, when you load your site, it pre-loads all of those specials before it completes the first page.

 

I suggest removing the scrolling specials box OR reduce the number of items on special.

 

 

 

Chris

Posted

Esther,

 

I appears you have scrolling specials on the website. And, you have 1370 specials loaded. That is why your site is loading very slowly. The scrolling specials box was not designed to handle that many specials at one time. So, when you load your site, it pre-loads all of those specials before it completes the first page.

 

I suggest removing the scrolling specials box OR reduce the number of items on special.

 

 

 

Chris

 

Hi,

I can't put all products on special? I know most of products are offered as special, but I thought I could do that.

I think the other solution is better, removing the specials box because it's not necessary if all items are on special.

 

Thanks.

 

Esther.

Posted

Hi Esther,

 

You have a similar problem with the scrolling What's New Box.

 

 

You should consider also removing that.

 

 

Chris

Posted

So what you are telling us is that you are asking questions here but cannot do anything with the answers. What's the point of answering your question then? :)

 

Hi,

I only want to improve my website. The man who do all website maintenance doesn't give us a solution so I try to search one.

When someone talks me about servers, add-ons and more..I can't do anything about that 'cause I don't understand anything, but when there's something to do with Oscommerce, something easy as changing some option, uploading images, adding description products...I can do it ;)

 

Also, thanks :)

 

Esther.

Posted

Hi Esther,

 

You have a similar problem with the scrolling What's New Box.

 

 

You should consider also removing that.

 

 

Chris

 

Hi Chris,

 

I'll try to remove the two boxes. I'll tell you whether or not it loads faster.

 

Thank you for your solution and patience.

 

Esther.

Posted

I only want to improve my website. The man who do all website maintenance doesn't give us a solution so I try to search one.

Hmmm, I would think that the cause and the solution of this slow-down would be obvious to someone skilled in the art of setting up osC websites.

 

See what the query is in the box Ofertas. For example in the box for Specials that Chris mentioned the regular osC limits the number of products with limit " . MAX_RANDOM_SELECT_SPECIALS

 

Either the limit is very high in that query or there is no limit (you can hard code it with limit 30 or any other number) causing it to load too many products.

 

Commenting out the include of the particular box in includes/column_right.php would indeed demonstrate if this is the problem of the slow loading:

 

   // include(DIR_WS_BOXES . 'specials.php');

Posted

Hmmm, I would think that the cause and the solution of this slow-down would be obvious to someone skilled in the art of setting up osC websites.

 

See what the query is in the box Ofertas. For example in the box for Specials that Chris mentioned the regular osC limits the number of products with limit " . MAX_RANDOM_SELECT_SPECIALS

 

Either the limit is very high in that query or there is no limit (you can hard code it with limit 30 or any other number) causing it to load too many products.

 

Commenting out the include of the particular box in includes/column_right.php would indeed demonstrate if this is the problem of the slow loading:

 

   // include(DIR_WS_BOXES . 'specials.php');

 

Hi again,

I tried to remove line 45 of tools>files>includes>column_right.php but it appears an error in the right column of the website.

I only erased the follow part of text: include(DIR_WS_BOXES . 'specials.php');

I'm sure there's something else I must do but I don't know what it is, anyone can help with this?

Thanks.

 

Esther.

Archived

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

×
×
  • Create New...