error 1226 : exceeded sql query limit

[gmoussa73]

ok, so did anyone face this problem with their host?

error 1226 : exceeded sql query limit

my host says that the queries reached 75000 per hour so the site closes down until the server resets the limit within an hour or two then the site comes back availabe again.......

right now i am the only person using the cart and the database for testing and setting up and its already closing the site on me...what will happen when visitors start trafficing through the site? then closing down every five minutes and customers will never come come back again.

their solution is to pay money to raise the limit for me to 150000 per hour or optimize my site....ok....paying more money is not an option as there is no guarantee that it will not happen again and what is the acceptable limit that can make things fine? they could go sipping money from my pocket until they drain me and still have the problem...loooool

now, any ideas how to optimise the queries of prestashop?
or
what is the best host out there who could host prestashop without problems?

thanx for the help in advance.........

[Patric]

Topic's title modified to comply with the forum's rules.

[gmoussa73]

after a while of search for a better host,looks like the problem should be first solved in optimizing the sql queries to the database....something is sending too much queries to the DB which makes it to surpass the limit per hour....then waiting for an hour to reset the queries and gain the site back.....

experienced guys plz hlp . we need you...give us a hand......what is the solution for this case?

[Vilas]

Hello,

 

Have you got solution on it? I am also facing same issue. I am using ipage hosting. Please suggest solution if you have.

 

Thanks