10
I have just had the same problem, to begin with they disabled my site as it was using 95% resources.
Caching everything doesn't work! If you cache something that is used all the time i.e. forum, and you put it on a low (30 seconds-5 minutes) cache. Instead this means more calls to the server, every 5 minutes or what ever you set it on.
Even after repairing problems in the database and removing items that are updated a lot, I am still using 45% resources.
I know my site has a lot of modules, yet this is something I want as it attracts more people to the site.
With caching I have now only cached, static content stuff that doesn't change.
Yet why is XOOPS using High resource, I use XOOPS 2.0.13.1?
I also recommend XOOPS logical checker if you are on 2.0.13 as it will check your database for errors!