Bleh

I've been down with a cold all week, which is why I've been less active than normal. I'm trying to finish translating Minx from the proof-of-concept model to the production design, but that's hard to do when your head is all squishy.

Worse, I think the cough that took me out for three weeks last October is coming back. Well, it's nothing like as bad yet, but it feels similar. Or maybe it's just a cough; I don't know.

I'd go back to bed except that it's nearly 30 degrees here at Pixy Central even with the air conditioner running non-stop.

I'd eat some ice cream except that seems to aggravate the cough.

I'd drink some of my nice iced tea except I already drank it all.

I'd go to the shop and buy some more except that it's even hotter outside, and as I said, my head is all squishy.

Meanwhile, I was doing some testing, converting all the munu blogs to Minx using my automagical converter program. Two problems cropped up:

First, it took 50 minutes to convert everything, which seemed a bit slow. It's less than 15 seconds per blog, and that involves pulling the data out of the old database as well as putting it into the new one (this is a direct db-to-db transfer rather than an export/import function) - but that's still slower than I'd hoped.

Second, the resulting database was nearly twice the size of the original Movable Type one. I know I have a lot of new fields to account for the extra functionality, but I was very careful about how and when and where they were added, so I was extremely disappointed to see that they caused that much bloat. Essentially, that would mean I'd need twice the memory on the database servers to handle the same number of users, which makes for a lot more expense.

And then I discovered a leetle bug in the conversion program. That caused it to copy each blog twice. Which would account for 50% of the slow and 100% of the bloat.

My head feels a bit better now.

Update: Well, it fixed the size problem. The speed problem, not so much. The code isn't the issue; 45 minute run time vs. 4 minutes CPU. I'll move on to the import routine and see if it's the pull/push nature that's slowing it down.

Update: The dread cough of doom seems to be in hiding. Let's hope it stays that way. It's also set to be a lot cooler the next few days, with predicted maximums of 23 to 23 degrees, where today it was as I said 30 degrees indoors with the air conditioner running...

Now if I could just lose the headache, I'd be almost happy.

Posted by: Pixy Misa at 12:19 AM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 465 words, total size 3 kb.