It's another of those things where the original author really didn't appreciate just how large a database it would end up dealing with. What was there was perfectly fine and functional while the site was small but became a problem later. Same is true of a lot of my code, so I'm tweaking the daylights out of things as I encounter them.