help! This Account Has Exceeded Its CPU Quota!

[graphicguy]

My account constantly gets suspended and its because I use to many resources on the server and the problem comes from using get. What can I use to use less resources?

HTTP Request: asdf.com : GET /page/count/633/ HTTP/1.1

This is the error I am getting!

[quote]This Account Has Exceeded Its CPU Quota 

Please contact this site's webmaster.

Wait a few minutes and use your browser's "Back" button or click here to try again.




--------------------------------------------------------------------------------
If you are the webmaster, your account may have exceeded for one or more of the following reasons:
Your site has used more than 20% of the cpu.
Your account has too many processes running at the same time.
Your site was consuming too many resources. This happens on occassion to very busy sites that have inefficient scripts running.
[/quote]

[trq]

Everytime someone requests a page on the web they are using http's get method. Sounds to me like you need more bandwidth.

[graphicguy]

Hey, I have tons of bandwith its using to many cpu resources for example this is one of them,

Sat Oct 28 06:21:15 2006: used 3.59 seconds of cpu time for HTTP Request: www.asdf.com : GET /page/count/733/ HTTP/1.0

I used $_GET alot for example,

$update = mysql_query("update users set date = CURDATE( ) where id = '$_GET[id]'");

[wildteen88]

GET shouldnt be eating up your CPU. It is your PHP script that is eating up your RAM/CPU. If you are using mysql queries then that is most probably the culprit. Try and optimize your SQL Queries/database structure

It doesnt matter how many GETs you use or what ever.

[.josh]

slightly off topic: you shouldn't be putting your $_GET variables directly into your queries like that.  This doesn't have anything to do with resources; it's a security issue.  Doing that makes your site ripe for sql injection.

Here's a thought: maybe someone has figured out this, and they are exploiting you. Have you checked any of your logs? checked your database?

[graphicguy]

[quote author=wildteen88 link=topic=113009.msg459169#msg459169 date=1162058093]
GET shouldnt be eating up your CPU. It is your PHP script that is eating up your RAM/CPU. If you are using mysql queries then that is most probably the culprit. Try and optimize your SQL Queries/database structure

It doesnt matter how many GETs you use or what ever.
[/quote]

Hey, How would I go about optimizing them to make them better?

[maddog39]

By using less queries and or combining queries using LEFT JOIN and also you could implement a page caching system.