I have been working very hard over the past few months to review each and every query on my phpBB boards and try to optimize it. I run a board that is now getting (on a fairly regular basis) over 250 concurrent users now, and this is on a server that I share with a few other boards. So it’s important that things perform at their best. I will be writing up some of the query tuning tips in later posts. As it turns out, my query tuning efforts probably helped, but that’s not where the bulk of my page generation times were coming from.
Not even close.