Monday, July 21

Geek

Gotcha, Evil SQL Monkeys!


Hello Pixy Misa, you are logged in to Minx.
87kb generated in CPU 0.07, elapsed 0.0883 seconds.
67 queries taking 0.0331 seconds, 236 records returned.
Powered by Minx 1.2b1.
Before an evening's hackery, it looked more like:
Hello Pixy Misa, you are logged in to Minx.
87kb generated in CPU 0.08, elapsed 0.2439 seconds.
92 queries taking 0.1803 seconds, 261 records returned.
Powered by Minx 1.2a12.
All in all, a worthwhile effort, methinks.

But optimising queries for MySQL really is a black art.

Actually, come to think of it, I didn't set up those new queries so they can be cached.  Let me fix that as well...

Okay.  A little less elegant, but 10% faster:
Hello Pixy Misa, you are logged in to Minx.
87kb generated in CPU 0.06, elapsed 0.0809 seconds.
67 queries taking 0.0256 seconds, 236 records returned.
Powered by Minx 1.2b1.
Every microsecond counts!

Overall, the Minx 1.2 beta is about 5% faster than Minx 1.1.  The engine is 10% faster, but the queries are 20% slower.  (Though I do have one more optimisation to throw in there.)

Given all the extra baggage it's carrying around - the template language has grown from 462 commands to 1634, and the codebase has grown by 40% - that's not too shabby.
Hello Pixy Misa, you are logged in to Minx.
89kb generated in CPU 0.07, elapsed 0.0843 seconds.
62 queries taking 0.021 seconds, 233 records returned.
Powered by Minx 1.1.1-aoi.
I do have to remember to make two minor but counter-intuitive index changes before I roll out the new release.  A strange beast is MySQL.

Posted by: Pixy Misa at 12:48 AM | Comments (2) | Add Comment | Trackbacks (Suck)
Post contains 263 words, total size 2 kb.

1 You realize that this violates the primary law of software development:  Updated versions must be (1) slower and (2) require more resources.  Or is that only major revisions?

Posted by: Old Grouch at Tuesday, July 29 2008 12:21 PM (/1RlR)

2 Well, at least it's way behind schedule.  Otherwise the universe might collapse!

Posted by: Pixy Misa at Tuesday, July 29 2008 01:18 PM (PiXy!)

Hide Comments | Add Comment

Comments are disabled. Post is locked.
42kb generated in CPU 0.03, elapsed 0.2057 seconds.
52 queries taking 0.1854 seconds, 283 records returned.
Powered by Minx 1.1.6c-pink.