My Server company fatcow recently gave me a warning that I have exceeded over 50,000 queries per hour over the last 7 days. Now I'm not sure how many queries I am getting now or if my visitors were getting any errors once the limit was reached. I do not see any current errors on the site. My question is - since I am getting a small amount of traffic at this point -usually under 60 visitors, is it reasonable to assume that a handful of users (the most I see online at any time is 4) can generate 50,000 database queries in one hour or is something broken? Will using cache help bring query number down? To implement cache is it just a matter of toggling to 'file' on the config file and specifying a cache directory?
Fatcow is suggesting that I cough up 20. a month for 150,000 queries per hour but I don't even know if this will be enough because I have no way of viewing number of queries during any given time frame.