3
whoa wait a minute:
They told you that info about php now tell me what's the system you are on, what's the the memory, cpu, what else is on your site, how many users a day, etc.
There are many other things that need to be looked at, do you have any odd modules installed like chat, lookup, database intensive ones. You really have to check what script is so intensive on cpu and db. As I always thought XOOPS is not database friendly it uses way too many calls to database (but it never should be a problem to such extent).
As andycornell wrote in previous post we need more info.