(2012-12-20, 07:02 PM)awtil Wrote: [ -> ]i have contacte my hosting support and i have this message
atabase '*****' has caused high load on our server.
(...) do you think that there is a bad file in translation or in the script? (...)
I think that you may have more sql queries than your host want to see,
and if you go above this limit - he may get angry and put an end to this. (which he did)
Additionaly on free host's (and it seems you use one) where they attach advertisements to your page,
Its important to them that your page should generate aproximately equal number of requests
to count of page refresh (advertisement reloads) and if you use ajax chat,
or some game scripts your page may generate many requests but not refresh page,
that also will make your host administrator angry.
Tell him to enable back your database and promiss that you will reduce your queries.
Then, when you are loged in as admin to your forum,
you can see at bottom of forum information about how many sql queries your forum generate.
- Each plugin may add to this value. So disabling some plugins may help reduce load.
- If you have Ajax chat/shoutbox - disable it, free host's hate it because it send requests,
but does not refresh page which then make situation where you
'increase server load but not display advertisements'
- Disable forum searching functionality, if you have big forum it may cause high load also.
- If you have option to chose your host PHP version, change to PHP 5.4.x, its faster, eats less memory and speed ups your forum.