mysql server load

[Daot Lagorille]

Holy crap.

It seems that every freaking query in my application maxes out the cpu load on the mysql server (it is a windows xp box).

I have made sure there are indexes on the fields that need them in the db, and the queries aren't that complex - like, I have basic joins (select * from table a, table b where a.****=b.****), but nothing more complex than that.

I have one page that has many different queries on it (like, 20?), though. Could this affect it?

Help....

[ShrineDesigns]

i would suggest you find ways to optimize your database and how you store data and the size of the data

an example of a join query:
SELECT * FROM `table_a` LEFT JOIN `table_b` ON table_a.field1=table_b.field2