1 Consider it so visualised

2 We were having a real issue with the performance of the MT trackback script - it was chewing up 200MB of memory at a time and taking several seconds to run. Not when someone sent us a trackback, but when someone looked up the trackbacks for a particular post. I was wondering how MT could possibly be screwed up so badly, even if we are stuck on an old version. Turns out that it wasn't MT at all, but MySQL. When we moved servers, it lost all its statistics on the indexes, so it stopped using them! (Insert as many exclamation marks here as you see fit. I think that three or four dozen should do.) I ran a table analysis, and the problem simply went away. Of course, I didn't work that out directly. It was only when my standard index page in _Minx went from taking 0.01 seconds to 3.5 seconds that I really started to look at the database. Now the only really poopy thing left with MT is the search script, which I may be forced to drag out behind the barn and shoot.

3 Oh yeah. I realised that this was the problem with the trackback script just as I got to that point in the post. Hence the neon lights, fire engines, etc.

4 When you shoot it, make sure there are no witnesses.... ;)

5 I can visualize it, even if I don't understand it.

6 That's why you should run MT on flatfile databases. No pesky index to think of!

7 I'm a duck. I'm supposed to understand this? As previously mentioned: I like pie.

8 I understand pie. Mmm-mmm, pie!