[eluser]alitech[/eluser]
Hey guys, I wanted to revisit this thread again to give everyone some updates on my success so far. I have managed to reduce the queries on each page to less than 40 everywhere. This has given an immediate speed boost to my site and its loading up much more faster. I am still looking to improve it a little more as I have now come accross other issues relating to DB connections.
I now often get TOO MANY CONNECTIONS errors on the site
Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/voucher/public_html/application/config/config.php on line 19
Not connected : Too many connections
Does this releare to the db not being optimised? The server seems to topple over when there are a few people on the site and requires the DB to be restarted to fix this. Not good!
I wanted to get the best resources to look into how I can optimise the DB. Does optimising the DB require code changes as well?
I am yet to apply Phil's library on the caching. THats a big excersize apparently because it touches every single DB query my developer tells me. Can anyone give me any ideas on how i can acheive the caching with phil's library as a quick win?
