Database query limitations?

[winkphoto]

I host several sites on I-Power and have OSC running on most of them.

 

One in particular keeps throwing up this error after one or two months, depending on traffic:

 

User 'XXXXXXXXXX' has exceeded the 'max_questions' resource (current value: 50000)

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

So, according to IPower, I have to create a new DB user and then go modify the config files to use the new DB user.

 

I've been doing this, but there has to be an easy way. At one point in time, they suggested that I could change OSC to use a different account to handle the queries.

 

Any suggestions from anyone?

 

Marc

[♥Vger]

iPower sells as cheaply as they do, with all of the features that they offer, because they absolutely pack all servers as full of websites as they can manage - and that's the answer to your question - you need a different hosting company.

 

Vger

[winkphoto]

Another hosting service is not an option, these sites are up and running, other than this one issue.

 

There has to be a way to fix this.

[♥Vger]

There has to be a way to fix this

 

Haven't you heard the old saying "You pay peanuts you get monkeys"?

 

There's nothing stopping you from building your existing site on someone else's servers, setting up your e-mail addresses etc. and then just repointing the dns addresses to the new servers when ready - keeping your old site active for a few days.

 

ISP's who have updated their records quickly will show the new site at the new address, while slower ISP's will continue to show the old site at the old address until they update their records. Within 3-4 days all ISP's will have updated their records and you can take down the old site and say "Bye Bye" to iPower.

 

Vger

[wheeloftime]

Another hosting service is not an option, these sites are up and running, other than this one issue.

 

There has to be a way to fix this.

 

Google on it and you will find some suggestions (ie. here on page 2). Most advised is however what Vger already told you; change iPower for something more solid.

[♥toyicebear]

1. Do not use STS on your sites if you use I-Power

 

2. Optimize your shop to use as few db queries as possible pr. page load.. there is a tread in the forum for just this..use the search and find it....

 

3. When you have reached the user limit, you have to make a new user....then you modify these 2 files with the new user/db info:

 

includes/configure.php

 

and

 

admin/includes/configure.php

 

B) :thumbsup: B)