Wednesday, November 30
So, I have this little program that converts Movable Type blogs, singly or en masse, into Minx blogs.* And I am trying out various queries to see how the database performs when it is actually using the indexes, and now and then adding a new index.
One of the indexes I added was on the number of comments on posts, so you can quickly see where the action is (or was). And the number one post, with 1633 comments, can be found here. I'm surprised the poor system survived.
MySQL takes 0.11 seconds to bring up those comments the first time; 0.03 seconds after they've been cached in memory. Whether this is a worthwhile achievement or not I will leave to Madfish's readers to decide.
* Not that I am working on Minx.
Posted by: Pixy Misa at
02:01 AM
| Comments (2)
| Add Comment
| Trackbacks (Suck)
Post contains 143 words, total size 1 kb.
Posted by: Madfish Willie at Wednesday, November 30 2005 12:24 PM (dcX0a)
Posted by: Anonymous Coward at Wednesday, November 30 2005 06:00 PM (sCYzS)
56 queries taking 0.2743 seconds, 339 records returned.
Powered by Minx 1.1.6c-pink.
