Tuesday, April 20
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.
Comments are disabled.
Post is locked.
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
06:06 AM
| Comments (1)
| Add Comment
| Trackbacks (Suck)
Post contains 137 words, total size 1 kb.
45kb generated in CPU 0.0143, elapsed 0.3568 seconds.
56 queries taking 0.3484 seconds, 327 records returned.
Powered by Minx 1.1.6c-pink.
56 queries taking 0.3484 seconds, 327 records returned.
Powered by Minx 1.1.6c-pink.