Help - live pages down. Provider says "SELECT SQL_CALC_FOUND_ROWS ..." is causing too many data requests

Our provider contacted us, because "SELECT SQL_CALC_FOUND_ROWS tblproduct.product_id, tblproduct.disable, tblproduct.contentnumber1, tbl ..." to many data requests, which are not completed. They say this impeded other websites on their server, so they shut ours down.

This has never happened before.

... until the data requests became too much again. The provider has no real clue, why this is happening. We suspected the contact page, because we have been receiving spam recently. They renamed the contact page and data stream was reduced, but just for a while.

The above mentioned log is still coming up.

My only guess is that you have a large database and an inefficient query causing the issue. I'd have to see the page causing the problem and possibly have access to the database to debug. The issue isn't with the rsobj.php file itself. It is probably an issue with inefficient recordsets.

You could try changing this line in the rsobj.php file:
$this->Prepared = true;

to:
$this->Prepared = false;

That would improve efficiency, but I generally don't recommend trying to change code to fix a problem until you have isolated it and fully understand the issue at hand.

I honestly don't understand the issue. The provider says, they don't know the problem. They suspect it could be a hacker.

They tried disabling the contact form, but that didn't help either. For now they disabled the page by commenting out the host on the connections page.

It could be a hacker making too many requests to that page. Perhaps they found a security hole and are trying to use that page to send spam messages.

I'm not sure why your contact page has a recordset on it to begin with. Are you sure that is the page causing the problem? Please attach a copy of that page and I'll take a look.

Every page has database driven content. That's why they all have record sets.

I am trying a temporary solution with godaddy. I will let you know how it goes.