Topic: Lack of indexes?
We've just switched the MacAddict Forums from phpBB to punbb. I've been eyeing PunBB for quite some time now, but first had to wait for 1.2 to be released, and then I had to get my act together. In any case, I hacked my way through the conversion this evening. We weigh in at over 700,000 posts, so I think we win the PunBB wang measuring contest. It would have been somewhere around 1.4 million to give you guys a real post count boost, but we lost all of 2003's post in a server crash (same week as you guys went down. Except we didn't have backups. Whoops.).
So anyway, after converting, I unveiled the new forums, and its processor usage instantly spiked to around 180%. And here I thought PunBB was going to be king of efficiency. I could restart the server, and instantly it was crippled within a minute to the point of non-usability. After trying to figure out just what was going on, signs finally pointed to the viewtopic page. Upon closer inspection, I soon discovered, that essentially nothing besides the primary columns are indexed in the tables. It was absolutely killing performance on pretty much any JOIN or WHERE clause. After adding a few indexes here and there, performance is awesome, although I'm still going to do a more detailed lookthrough whenever I get the time.
Anyway, just wondering if there was any reason for this / making you guys aware.