April 19, 2004

Geek

Who Let The Brap Out?

I can't for the life of me work out why the mt-db2sql.cgi program is so slow. I put both the Berkeley DB (the old database) and the MySQL DB (the new database) in a ram disk, and it behaved exactly the same. Moofleglerp.

I'm familiar with Berkeley DB, and I've never seen it behave like that. I'm less familiar with MySQL, but I've never seen MySQL behave like that either. Right now I'm trying it with PostgreSQL, and any moment now... Crunch! As soon as it finishes with the comments and starts transferring the entries, performance drops to zero. It's not CPU bound, it doesn't seem to be I/O bound, it just sucks.

Well, I'll let it finish anyway, and then I'll have more numbers for comparison.

Posted by: Pixy Misa at 08:06 PM | Comments (2) | Add Comment | Trackbacks (Suck)

1 Perhaps there is a voodoo curse upon them? Did you remember to clear your throat three times before sacrificing the iguana?

Posted by: Susie at April 21, 2004 12:52 AM (mPuO+)

Hide Comments | Add Comment






Processing 0.01, elapsed 0.0075 seconds.
16 queries taking 0.0043 seconds, 23 records returned.
Page size 7 kb.
Powered by Minx 0.8 beta.