Monday, July 21
Gotcha, Evil SQL Monkeys!
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:
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.
Comments are disabled.
Post is locked.
Hello Pixy Misa, you are logged in to Minx.Before an evening's hackery, it looked more like:
87kb generated in CPU 0.07, elapsed 0.0883 seconds.
67 queries taking 0.0331 seconds, 236 records returned.
Powered by Minx 1.2b1.
Hello Pixy Misa, you are logged in to Minx.All in all, a worthwhile effort, methinks.
87kb generated in CPU 0.08, elapsed 0.2439 seconds.
92 queries taking 0.1803 seconds, 261 records returned.
Powered by Minx 1.2a12.
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.Every microsecond counts!
87kb generated in CPU 0.06, elapsed 0.0809 seconds.
67 queries taking 0.0256 seconds, 236 records returned.
Powered by Minx 1.2b1.
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.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.
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.
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!)
46kb generated in CPU 0.0339, elapsed 0.1574 seconds.
56 queries taking 0.1342 seconds, 347 records returned.
Powered by Minx 1.1.6c-pink.
56 queries taking 0.1342 seconds, 347 records returned.
Powered by Minx 1.1.6c-pink.
