Hi, for a long time now we have had speed issues with our site, this seems to be related to database intensive pages such as static category pages products.asp etc.

EG this is the response on a static page

URL: http://www.bikermart.co.uk/motorcycle_indicators.asp
Host: www.bikermart.co.uk
IP: 81.88.60.34
Error/Status Code: 200
Priority: VeryHigh
Client Port: 53386
Request Start: 0.167 s
DNS Lookup: 27 ms
Initial Connection: 140 ms
Time to First Byte: 7347 ms
Content Download: 483 ms
Bytes In (downloaded): 47.5 KB
Bytes Out (uploaded): 0.4 KB

And the same thing with a category page

URL: http://www.bikermart.co.uk/motorcycle_lighting.asp
Host: www.bikermart.co.uk
IP: 81.88.60.34
Error/Status Code: 200
Priority: VeryHigh
Client Port: 64306
Request Start: 0.175 s
DNS Lookup: 27 ms
Initial Connection: 148 ms
Time to First Byte: 506 ms
Content Download: 151 ms
Bytes In (downloaded): 8.1 KB
Bytes Out (uploaded): 0.4 KB

In the first instance time to first byte is over 7 seconds and the latter is .5 seconds.

Can anyone please shed a light on this.

Thanks
Simon

Hi Simon

The first page is showing 60 products per page and in those you have ratings, descriptions, options, add to cart etc.

The second page shows only 6 items without those extra overheads.

If it was my site I would reduce the number of products per page and use a "leaner" layout for the products page, something along the lines of our demo store here

http://ectwp.com/products.php

Andy

Please feel free to review / rate our software

Not much faster with 20 products as below..

URL: http://www.bikermart.co.uk/motorcycle_indicators.asp
Host: www.bikermart.co.uk
IP: 81.88.60.34
Error/Status Code: 200
Priority: VeryHigh
Client Port: 52676
Request Start: 0.167 s
DNS Lookup: 27 ms
Initial Connection: 140 ms
Time to First Byte: 4513 ms
Content Download: 313 ms
Bytes In (downloaded): 26.7 KB
Bytes Out (uploaded): 0.4 KB

I am sure other sites have many more than 20 products visible per page..

Regards

I'm pretty sure that is the reason why the page appears slow and when you reduce the number of products the content download time decreases.

Andy

Please feel free to review / rate our software

I have disabled the small description but co change. When i do a product search on the wheel site it takes 12 seconds to come back with a result.

http://www.bikermart.co.uk/search.asp?pg=1&stext=memphis&sprice=&stype=&scat=&sfil0=

??

Hi I took a quick look using https://gtmetrix.com/ the image compression needs work, leverage browser caching, doing these can increase the speed. A good tool for image compression is tinypng.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

So 12 seconds for a search does not sound unreasonable.

Thanks
Simon

If you are using an Access database, you may want to consider doing a "repair and compress."

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

I tried the search and it took me a lot less than 12 seconds and my connection isn't that great today either.

I would look at Sinbad's suggestion for optimizing images. For example the Special Offer image top right is 25k. I opened it up in Fireworks and exported it with no noticeable loss of quality to a 7k file. I uploaded it here for you



If you go here https://developers.google.com/speed/pagespeed/insights/ you can download some Google optimized images - that will change the gif images to png files.

Andy

Please feel free to review / rate our software

Oh yes - "repair and compress." can also help. Moving javascript tags out of the head section to the bottom of the page above the closing </body> tag is another page optimization technique.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Thanks everyone I will look at your suggestions. Just confused me that there was a long delay and then everything suddenly shows up.

All the other site pages including index load really quickly.

Cheers Simon

Where do i start with leverage browser caching ?

Have a look at the suggestions here

https://stackoverflow.com/questions/21074198/leverage-browser-caching-in-iis-google-pagespeed-issue

https://forums.iis.net/t/1196324.aspx?iis7+Leverage+browser+caching

... but make sure you test the site afterwards to make sure adding to cart and / or cart contents isn't affected by the change.

Andy

Please feel free to review / rate our software

I have used this..

<staticContent>
<clientCache cacheControlMode="UseExpires" httpExpires="Tue,19 Jan 2038 03:14:07 GMT"/>
</staticContent>

Seems to have made a change on google pagespeed, still mentions leverage but less of a priority..

Orders still coming through so all seems ok with functionality.

Many thanks

I really wouldn't set caches in a dynamic website. The idea is that you are serving up different content unique to each visitor and there may be other things you can do to the database to improve things there.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Sorry to resurrect this topic, but I have realised that all the suggestions re image sizes and page overheads are irrelevant it seems because the speed problem is also present in the admin pages.

I was just clicking on an order (todays orders) to go to the order details and that took approx 5 seconds for the server response, leading me back to the thought that I have database speed issue..

I have used your database check service previously and you found no fault, i have compacted and repaired several times too.

What else can be done.

Thanks

Hi Simon
Are you using SQL Server by any chance? There is now a Database Utility menu under the "STORE ADMIN" menu, and under that is an NVARCHAR to VARCHAR utiltiy for SQL Server. It's improved the speed of some sites a great deal. But saying that, I wouldn't expect it to influence the admin section much as those pages are pretty lightweight. Have you asked your host to get involved in this? There is a pretty cracking host who deals a lot with ECT sites at servelink.net and I've even known then to set up your site on their servers if you are thinking of switching to see if the performance improves.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

No not SQL..

It seems that everything else is nice and quick, on site all the categories come up quick but products and proddetail page slow. When using admin invoices come up quick but when clicking onto an order detail it is slow..

Flummoxed !!

Have you considered switching to SQL Server, or as Vince says looking at an alternative host like servelink.com?

Andy

Please feel free to review / rate our software

What is involved in switching to SQL ?

We have some details on making the switch here https://www.ecommercetemplates.com/help/ecommplus/instructions.asp#sql

Andy

Please feel free to review / rate our software