So I’ve been obsessed with this for a few weeks now ever since I discovered that PGN’s frontpage generates more than 350+ queries after turning on the debug mode for Joomla. I was literally shocked because when PGN was still using Joomla 1.0.x it was only using around 100+ queries and here I am thinking that Joomla 1.5.x was better right? Anyway, I tried to figure out what’s causing this massive amount of queries. My first thought would be the SEF component that I’m using which. After disabling it, queries went down by half. So my second guess would be that Joomla’s SEF is generating those queries since obviously my 3rd party SEF manager was generating more right? So I turned it off and queries has gone down to just 120+. So I was already satisfied because it was close to the old website’s amount of queries. Then I told myself, well I can’t really run a live website like this right? I mean the URLs are ugly so I had to turn everything back on and figure out how.
So here’s my initial steps…oh and you’d be surprised at the end too. Enjoy!
3rd party SEF turned on – 331 queries logged
3rd party SEF turned on with Permanent Cache – 145 queries logged
Cache Settings (not the system cache) turned on – 53 queries logged
Did it reduce page load time? I’m not really sure I can feel any difference. It still loads fast for me.