My host just cut off MySQL access for my work site because it was putting too much load on the server and crashing it.

Can someone tell me what is a 'normal' or 'acceptable' number of SQL queries for a XOOPS site?

I turned on debug mode and found my home page used an average of 90 SQL queries to load, which seems like quite a lot. I managed to get it down to 18 by turning off a few blocks (notably the 'xm-memberstats' block which used about 34 queries, and 'waiting contents' which used 11!) and by enabling caching.

I got virtually no improvement from module-wide caching, but turning on block-level caching cut another 13 queries.

So overall I got about an 80% reduction in the number of SQL queries, I hope my host will be happier...wish I'd looked at this a couple of years ago!

But what is an acceptable range?

Maybe doesn't exactly answer your question, but quite a good article ;o)

xoops-tips Cache for Performance