blakeaf96 Posted June 2, 2011 Share Posted June 2, 2011 Okay - www.gunsngoldonline.com - It's built with OsCommerce. We have 26,000 products on it. Server load is VERY low, so it's not a server problem. The graphics aren't that large. The website connects to an external database to pull products onto the website. For some reason, our website is VERY, VERY slow - 13.75 response time roughly when loading pages. We are very frustrated and don't know what to do! Please, someone help!!! Link to comment Share on other sites More sharing options...
burt Posted June 2, 2011 Share Posted June 2, 2011 1. Use of STS will slow a big oscommerce site down. 2. Put things such as .css into included files 3. Strip down your HTML as much as you can 4. Improve the SQL queries as best you can 5. Get rid of some of the "cool" stuff like the cursor Link to comment Share on other sites More sharing options...
blakeaf96 Posted June 2, 2011 Author Share Posted June 2, 2011 1. Use of STS will slow a big oscommerce site down. 2. Put things such as .css into included files 3. Strip down your HTML as much as you can 4. Improve the SQL queries as best you can 5. Get rid of some of the "cool" stuff like the cursor Would the Cursor and CSS make THAT big of a difference? And what is STS? I'll get my developer to check on the SQL queries. Thanks for your help! Link to comment Share on other sites More sharing options...
burt Posted June 2, 2011 Share Posted June 2, 2011 Many small gains add up to a big gain, right? Suggest you work first on SQL queries. Then removal of STS, your developer should know what that is. Benchmark as you go so that you get a handle on the improvements as you go along. Link to comment Share on other sites More sharing options...
blakeaf96 Posted June 2, 2011 Author Share Posted June 2, 2011 But won't getting rid of the STS require a LOT of work? Or is it fairly easy to get done? Link to comment Share on other sites More sharing options...
burt Posted June 2, 2011 Share Posted June 2, 2011 Are you expecting the site to become faster without significant work? ;) Start with the SQL queries. Link to comment Share on other sites More sharing options...
blakeaf96 Posted June 3, 2011 Author Share Posted June 3, 2011 Many small gains add up to a big gain, right? Suggest you work first on SQL queries. Then removal of STS, your developer should know what that is. Benchmark as you go so that you get a handle on the improvements as you go along. Just with the queries, I got it down from 14 seconds to 8 seconds... there was 296 queries just for the homepage. Got it down to 115 queries and 8 seconds. Still kinda slow - ySlow gives it a score of a B from A-F. Any further suggestions? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.