Guys, I am running an active site with a very large number of sql queries per page. Whenever I get over a certain amount of traffic (I am guessing about 100 or so on the site at a given time) the site starts bogging down from all the queries. I looked at my WHM info and saw that mysql is using 17.55% CPU and 32% of memory. How bad is this, should I buy more memory? There is some optimization I can do to the code, but I am still developing the site and need to finish development before I can optimize.
