In the first post in this series I talked about the fact that phpBB2 already provides a mechanism for counting queries that are used to generate a page. Now I am going to take that a step further. For optimization purposes, I want to know how long the query processing took.
February 29, 2008
February 28, 2008
Most phpBB users really like the “orange thingie” that takes them to the newest post in a topic. (This feature, like many, is only available to users that are logged in.) The image is this one: I like it too. I like it even more since I optimized the query that drives this functionality.
Edit: This post turns out to be wrong. I am leaving it in place, but the code suggestions made here are not effective and in fact will generate SQL errors in certain cases. More details are in the first comment at the end of the post.
February 27, 2008
I was taking to someone via IM the other day about phpBB. This person runs a board that is fairly active and caters to a certain demographic that from what I can tell more challenging than some others to manage. During the conversation they mentioned that at one point they were talking to someone else who ran a similar board, and that person linked them to an article that they had read about separating the admin duties from regular participation on the board.
The link was the “Don’t Log In as Administrator” post that I made on the Doctor Board some time back. If you haven’t read it, the point of the article is that you should not make your user name (your “regular” user name) an admin account. Set up a separate account, even call it “Administrator”, so you can post whatever you want as your own account and then do the board management as the administrator account.
Anyway, the point was this other person had no idea the person they were talking to had already been using me for some small services for their board. It was quite rewarding for me, actually, as I never know who might be visiting or what sort of value they might be getting from my site. It’s nice to know that someone finds my ramblings useful.
February 26, 2008
A standard footer for phpBB2 boards includes the copyright (of course, you would not leave that off, would you? ) and various other things. It does not include any page generation statistics. There are a couple of MODs that will do that, and most are quite simple. For example, to echo the number of queries that it took to generate the page is incredibly easy to do.
February 25, 2008
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.
February 24, 2008
It has been many long months since my last post on the Doctor Blog. One reason is that my project in “real life” went live towards the end of December, and that involved a lot of extra time. We took a family vacation. My oldest boy is in cub scouts, and both boys just started soccer. Life is busy. Good, but busy.
Lately, though, I have been digging in to the reason why some of my pages take so long to load on my largest board. Some of the findings are a bit surprising, and I plan to write them up as I go along. For now, welcome back. To me.