Oscommerce going dead-slow

[MLu]

Over the past three years I have moved from shared hosting to now a VPS server, but my sites continue to be slower and slower. Is is especially database updates that are slow, and one major problem is that the number of orders that being mistakenly entered twice or more, grows. This of course is due to customers being impatient when waiting 20-30 secs from pressing the order confirmation buttom without anything happening.

 

I'm doing a regular optimizing of my databases via cpanel, I delete for example visitor statistics, but the orders* files I have never touched. Am I missing some clean-up routines that are needed?

 

Are there any settings in MySQL that could be tweaked to make especially oscommerce work better. I guess that MySQL has a standard configuration, but do not know a lot about these issues. But I have the luxury to only host my 4 oscommerce sites, so no-one else would suffer from changing any parameters.

 

I would really love some hints and advise here - thanks :D

 

Mogens

[khime]

I use a VPS aswell and I find that it runs really slowly sometimes and its not dependant on the number of customers browsing.

 

May have to do with the other people using the processing power for the shared CPU. Even though you have control of the settings you still have to share resources with other users

 

Maybe worthwhile to ask your VPS provider to see if anyone hammering the CPU load

[Guest]

you should install some of the cache modules available from the contributions.

[MLu]

I use a VPS aswell and I find that it runs really slowly sometimes and its not dependant on the number of customers browsing.

 

May have to do with the other people using the processing power for the shared CPU. Even though you have control of the settings you still have to share resources with other users

 

Maybe worthwhile to ask your VPS provider to see if anyone hammering the CPU load

Khime, I have tried during a long time to get a clarification from my - otherwise very good - webhost about this. I had a feeling that maybe the server I was on was perhaps overloaded, but I had this very clear answer the other day which seems to be direct in opposition to what you write:

You selected the vps-1 package which comes with 256 MB of guaranteed RAM. The fact of the matter is that if your VPS requires, on a prolonged basis, more than this you will see periods of slowness or heavy load.

 

Please note that the VPS hosting platform is very different from shared hosting in that the load of one VPS is dependant just on what that single VPS is doing without any reliance on other VPS's on that physical server. There is total separation which means that while one VPS may be struggling and under high load, there can be (and are) other VPS's on that server with zero load because they're hardly doing anything. Therefore, a move to a new node will result in the *exact* same situation because the package specs are exactly the same.

 

There are two solutions here:

 

1. reduce the power (cpu/ram) requirements of the vps by disabling some services, removing some sites, etc (we can help with this)

 

OR

 

2. give it more power to use by upgrading to a package with more cpu/ram

 

I am a bit confused here, but this issue is hard to look into :( I believe what he writes is correct, but I simply do not understand what causes the huge variations in load, and sometimes up to minutes of waiting time. My recent upgrade to a bigger VPS gave me a slightly better performance but not as I had in the good old shared hosting days with the same webhost.

[MLu]

you should install some of the cache modules available from the contributions.

Any particular ones you can recommend? I've heard that some of them does not do much good.

[Guest]

Any particular ones you can recommend? I've heard that some of them does not do much good.

yea? where do you hear these stories?

 

try this one:

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

 

also if you don't have the ultimate seo urls installed you can check this one too:

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

if you do have them you don't need it because it is included. But you do need to utilize the cache with this module.