CPU Spike and Query's

[bada_bing]

I was recently informed by my hosting provider that my site is causing 44 queries on every thread view. I am also being told that my site is eating up 60% of a quad core processor. My site is a pretty active site but also has lots of mods. What I want to try and do is figure out which mod is causing CPU spikes and high queries. Is there a way in VB to easily check this without disabling one hack at a time?

[Lynne]

What I do is have a test site and keep it in debug mode. That way, at the bottom of every page I see how many queries there are and can click a link to see all the actual queries made. I can turn on and off mods to see how they effect the page. Try that with your site.

[bada_bing]

Do you think its ok to enable debug on a production site? Also I was told that enabling ajax on vb is not good? I currently have ajax enabled but not for problamatic ajax features, is this ok ?

[Lynne]

It is not suggested to enable debug mode on a live site which is why I said to do it on your test site. If you have to see something on a live site that isn't available on a test site, you can turn on debug just for your IP (search the articles forums for an article on that).

I really can't answer your question about ajax. I would guess that your server situation would come into play in answering that question.