Wednesday, November 30

Blog

For A Few Comments More

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.

1 I'm in the midst of a 'Pixy-Lanche"... I'm thinking that the linked post must be a record for comments... I've checked some KOS and LGF posts and only a couple of those are over 1500... WooHoo for Madfish Willie!!

Posted by: Madfish Willie at Wednesday, November 30 2005 12:24 PM (dcX0a)

2 Admit it, you are working on Minx, aren't you?

Posted by: Anonymous Coward at Wednesday, November 30 2005 06:00 PM (sCYzS)

Hide Comments | Add Comment

Comments are disabled. Post is locked.
44kb generated in CPU 0.23, elapsed 0.4446 seconds.
56 queries taking 0.3153 seconds, 317 records returned.
Powered by Minx 1.1.6c-pink.