Sql query cpu usage?

[Hex]

Hello :D

I've got a customer who uses alot of SQL resources with all these queries. He's doing close to 1,000 queries/hr, and I dont know if that will absolutely kill the CPU in the vds, or if it might lag it to all hell.

Anyone have any insight on this?

[Michael]

What does the server load look like? Regardless..if it becomes too much you'll noticed queries will take a longer period of time to execute and return results if any.

[MQ-James]

different types of querys do different things, I found insert take more CPU/memory than a select query. Also if the query does a lot it will take more cpu than a simple query, and if you structure your querys so they are as friendly as possible it will help, as in use field names as opposed to * in your select querys.