finding_peace
New member
Hi everyone! One thing that really helped me improve page performance was to optimize my queries. Especially if you have custom mods (or even official ones), queries can start to get out of control really fast.
I cut down my FORUMHOME queries from 130 to 20, and CMS from 270 to 83. Probably even more important than number of queries is the performance of those queries. I found multiple queries taking 0.1-0.4 seconds (which may not seem like a lot, but it adds up VERY quickly). Really I don't think any queries should need to take longer than 0.01 seconds.
Is there any sort of guide around here that shows how to enable the debugger and find slow & inefficient queries? If not, I'd be happy to work on one. Would definitely want feedback though, as I'm not an expert with this.
I cut down my FORUMHOME queries from 130 to 20, and CMS from 270 to 83. Probably even more important than number of queries is the performance of those queries. I found multiple queries taking 0.1-0.4 seconds (which may not seem like a lot, but it adds up VERY quickly). Really I don't think any queries should need to take longer than 0.01 seconds.
Is there any sort of guide around here that shows how to enable the debugger and find slow & inefficient queries? If not, I'd be happy to work on one. Would definitely want feedback though, as I'm not an expert with this.
Last edited: