Does osCommerce but a lot of strain on database servers?

[subzerostudio]

I have had lots of problems with a hosting company that I use for lots of oscommerce sites. The company I use is a UK based one called 1&1.

 

Basically some sites on their servers have started to run very very slowly - due to their busy database servers.

 

I wrote them a letter stating I wasn't happy with their service, and they replied with the letter below. Basically stating that MY site was slowing down the ENTIRE database server, and was putting an 'unacceptable load' on the server.

 

The site is pretty much bog standard osc, with a new template and stuff. But currently can take up to 2 minutes to load the page.

 

So whats the deal? Are they just fobbing me off? They appear to be stating that oscommerce can not run on their shared servers. Which is simply not true.

 

Mike

 

It has come to our attention that your account database;

 

{db acct no here}

 

has been flagged up by the administrators for taking up too many

resources on the database server.

Please note that being on a shared hosting platform the database server

resources are shared amongst other users. There has been a performance drop on the server

due to the resources that are been taken up by your database.

 

 

*** dbo150872547@infong356: 27728 Queries: 27454 Selects, 32 Ins, 187

Upd, 55 Del, 55 Connects

 

rdb43:~# mysqladmin proc|grep dbo150872547

| 1281473 | dbo150872547 | 212.227.119.172:61593 | db150872547 | Query

| 1 | Opening tables | select c.categories_id, cd.categories_name,

c.parent_id from categories c, categories_description cd |

| 1284472 | dbo150872547 | 212.227.119.172:64156 | db150872547 | Query

| 3 | closing tables | select c.categories_id, cd.categories_name,

c.parent_id from categories c, categories_description cd |

| 1284683 | dbo150872547 | 212.227.119.172:64361 | db150872547 | Query

| 0 | Opening tables | select c.categories_id, cd.categories_name,

c.parent_id from categories c, categories_description cd |

| 1284743 | dbo150872547 | 212.227.119.172:64423 | db150872547 | Query

| 1 | Opening tables | select c.categories_id, cd.categories_name,

c.parent_id from categories c, categories_description cd |

| 1284804 | dbo150872547 | 212.227.119.172:64477 | db150872547 | Query

| 1 | closing tables | select count(*) as count from banners_history

where banners_id = '1' and date_format(banners_history |

 

 

Please review the database scripts and make them more efficient.

 

Another possibility made available is to migrate the WebSpace to a managed or dedicated server.

You would have full resources of the machine and do not effect other users.

 

We would also like to bring your attention to the T&C's that are in

place:

 

T&C's

--------

Hosting resources are limited due to the shared hosting nature. Our

terms and conditions

(http://order.1and1.co.uk/xml/order/TcGeneral) clearly state the

following :

 

6.2

The Customer shall NOT:-

 

6.2.6

 

Arrange its home page(s) in a way that leads to a risk of or causes an

excessive load on the server

provided by the Company in connection with the Services;

 

11.1

 

The Company shall be entitled to suspend such access to the Services as

it deems necessary by the

Customer or any third party to all or any party of the Services if the

Customer is in breach of any

of Clauses: 5, 6.1.4, 6.1.5, 6.1.7, 6.1.9, 6.2.2, 6.2.3, 6.2.4, 6.2.5,

6.2.6 and 12. This Clause

shall not be construed in any way as limiting the termination rights of

the Company as provided by

Clause 8.

 

Please note that the only solution on our services that is capable of

accepting such a load is one of

our dedicated solutions, Please see the link below

 

http://order.1and1.co.uk/xml/order/ServerManaged;

 

--

Sincerely,

Asif Ali

Technical Support

1&1 Internet

[Jack_mcs]

Others on the forums have stated problems with 1&1. I have not had any experience with them so I can't say. They are probably being truthful in what they are saying but the problem is that their limits are set too low for your site to run without problems. There is a thread about optimizing an oscommerce shop but you should not have to do that for a basic shop. And you shouldn't have to pay extra for a dedicated server to get your site to run. If you move to a host that can handle oscommerce, you won't have that problem. I think that is your only real choice.

 

Jack

[digbydo]

I agree with Jack, there's been loads of problems with 1&1 and I've gained a few clients from them but don't just take our word for it:

http://groups.google.co.uk/group/alt.www.w...;scoring=d&

By the way, they are actually based in Germany as Schlund & Partners. :)

[digbydo]

A quick search on google found this: ADVERT SNIPPED

 

I'm VERY surprised you needed to look on Google to find your own site Stuart :-"

[subzerostudio]

I'm VERY surprised you needed to look on Google to find your own site Stuart :-"

 

Hm, I got a personal message with a link to the same site from a different member.. how odd.. B)