Site is very slow, ISP said not their problem

[videobus]

I have a client site at www.broadwayvideo.info that was working for over 4 months with no problems. 4 days ago the site became very slow just to fill the screen where it reads the data from mySQL. There were no changes for over 45 days, so it's not the last change that was made.

 

The ISP www.1and1.com claims it's not their problem. They did a lot of tests that shows everything is working on their side.

 

I have category counts disabled in the top left box, which I know takes a lot of time to count if enabled. This site has about 25k items in inventory and the ISP claims that's why it's slow. I tried to explain to support that it worked fine for all these months and then it became umbearable slow within the last 4 days.

 

To make a long story short, they said if you don't like it go somewhere else.

 

Anybody have any ideas for me? It would be greatly appreciated.

 

Peter

[Guest]

I have a client site at www.broadwayvideo.info that was working for over 4 months with no problems. 4 days ago the site became very slow just to fill the screen where it reads the data from mySQL. There were no changes for over 45 days, so it's not the last change that was made.

 

Well if you're on a shared server expect fluctuations in server performance subject to what other users do, therefore you could use few cache modules to speed up your store.

http://www.oscommerce.com/community/contributions,5029

http://www.oscommerce.com/community/contributions,2873

 

I have category counts disabled in the top left box, which I know takes a lot of time to count if enabled. This site has about 25k items in inventory and the ISP claims that's why it's slow. I tried to explain to support that it worked fine for all these months and then it became umbearable slow within the last 4 days.

 

Lots of time? Well it does extra queries without cache, but once you cache it can be 0 or 1 queries.

So you don't need to drop features to increase performance.