Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sooooooooo sloooooooow


WebMistress

Recommended Posts

can anyone tell me why this site is so slow???

 

I have considered pasting the database data here - because it became very slow after we changed the category structure. I optimized the tables, but no help.

 

also if you look at the german or spanich there seems to be some error and I wonder if the problems are related. I installed so many modules on this thing I am concerned that I wont be able to find the prob....

 

also this is an adult video store...

 

http://www.nastylittlestore.com/catalog/

Link to comment
Share on other sites

First of all, remove the "count" in your categories.

This is the test results for your page

Loading test content results

Number of graphics/scripts: 67

Total graphics size: 28498 bytes

Total HTML size: 29867 bytes

Total page size: 58365 bytes

Load time by modem speed

Modem speed: Download time:

14.4k 35.29 seconds

28.8k 19.07 seconds

56k 11.11 seconds

ISDN (128k) 6.5 seconds

T1 (1.44 MB) 3.18 seconds

 

Warning!: Your loading time is not bad... However, a top performing web site will load under 14 seconds at 28.8k.

 

HTH

The_Bear

Link to comment
Share on other sites

Adding indexes to your database could help as well. If you have a lot of products the following index will help:

ALTER TABLE `products` ADD INDEX Status (products_status);

 

I would add this one as well:

ALTER TABLE `products` ADD INDEX manufacturer (manufacturers_id);

Link to comment
Share on other sites

Hey Bear, what did you use to get those statistics?

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Webmistress, take a look at the reviews box on a product page. Your highlighting is causing the text to not appear unless you hover over it.

 

For the login box, in the German and Spanish languages, you are missing the entries:

BOX_LOGINBOX_HEADING

BOX_LOGINBOX_EMAIL

BOX_LOGINBOX_PASSWORD

 

As well as product descriptions.

 

Are you on a shared server or dedicated?

Are you using GZip compression? If so, what setting?

Are you using cacheing?

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

thank you for your reply, Deamon, I do know about the errors on the german & Spanish, also if you look at the categories info box thers virtually nothing there, except the arrows which are the only links to the categories.

 

I don't know why the login box is not appearing either, and honestly I don't remember where to look.

Link to comment
Share on other sites

to answer you questions, I am on a virtual server. but I'm not having this problem on other carts on this server.

 

also just enabled cache about an hour ago ( to try to speed things up) and reset gzip to 9

 

what are you thoughts?

Link to comment
Share on other sites

I'm not sure why the reviews is the only one doing that (green)

 

.infoBox {

 background: #66CC99;

}



.infoBoxContents {

 background: #FFFFFF;

 font-family: Verdana, Arial, sans-serif;

 font-size: 10px;

}



.infoBoxNotice {

 background: #FFFFFF;

}



.infoBoxNoticeContents {

 background: #FFFFFF;

 font-family: Verdana, Arial, sans-serif;

 font-size: 10px;

}



TD.infoBoxHeading {

 font-family: Verdana, Arial, sans-serif;

 font-size: 10px;

 font-weight: bold;

 background: #66CC99;

 color: #ffffff;

}



TD.infoBox, SPAN.infoBox {

 font-family: Verdana, Arial, sans-serif;

 font-size: 10px;

}

 

is what I'm using - is this the right place to modify

Link to comment
Share on other sites

Make sure the cache is in your webspace (/home/[user]/tmp) and not the server's (/tmp/).

 

A nine for GZip should be fine.

 

The stylesheet is the place to edit, but the review box uses the boxText class.

 

For the login box, those entries mose likely go into the main language file if there is not a dedicated language file for it. Check the readme on the contribution.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

hi Deamon,

 

cahce is good, gzip food, still can't find the correct css - the boxText class doesn't show a background color I htnk it must be one of the back ground colors is off - but not sure which one span's the review info box...

 

I will look into the login contrib - that makes sense... I must have missed the language file on that install

 

appreciate all your help

 

Venus

Link to comment
Share on other sites

If the boxText class does not have a background, then the background from the anchor tag will be used.

 

Otherwise, it will be the background from the table surrounding the review text.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

A nine for GZip should be fine.

 

After a setting of 1 or 2, the benefits received by compression are outweighed by the extra processing power needed on both the server and client machine with gZIP.

 

In fact, using higher compression settings may put you over allowable resource usage on a shared server with a couple of hundred customers on it.

 

Turn off gzip and check your site here, http://leknor.com/code/gziped.php. Then play with the settings to achieve a balance between server load, download size and rendering time.

 

Also note that on older computers, GZIP will actually increase the amount of time your page takes to load.

Link to comment
Share on other sites

btw do you look anything like your avatar?

 

My wife says no...

 

good answer, that's too bad, he's very attractive. Smart too.

 

the good one's are always taken!!!!

 

 

Thanks fo ryour help, very much.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...