-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Good evening, Benjamin...
On Monday 27 January 2003 07:56 pm, Benjamin Pflugmann wrote: > You are aware that 4.0.9 is current? <huge blush> Yes, as of this evening, I became aware of it. God, how time flies when you're having too much fun! > So it's also possible that it was a glitch in the beta version you > used before and that was fixed in the meantime. The out-of-the-box > comment is only meant for the most recent version, 4.0.9, of course. That would explain why, just minutes ago, after I completed testing the precise same pair of indexed 100,000 record tables, everything worked normally 100% of the time. I guess I should have checked back more often to see the status of MySQL, but I've been pretty busy, and didn't notice the changes taking place beneath my nose. They obviously have optimised quite a bit since my last test, based upon what I've seen just this evening. They have apparently improved Innobase, although I'm not certain if I'm seeing changes to it, or merely the tremendous influence of the cache at work. Even on multiple complex JOIN statements MySQL *flies* as never before, even on limited hardware. My test base, a 333 mz Pentium II with 128 M of memory, was chosen for its hardware anemia, to see if the original performance benchmarks as printed for 3.23 were improved. They most certainly *ARE* improved. To answer a question someone asked earlier, I restored some 800,000 record tables off an old backup tape (pre-3.23, but I don't remember the version) and plopped them onto the development machine, and they worked flawlessly but with a noticeable performance improvement, even without allowing for the lack of a decent hardware platform. I ran a few record-locking routines under Innobase to do a "poor man's" verification that record locks work as well as rollover, and they do work without exception. Perhaps even more important, 4.09 didn't break *any* of my Delphi code, which means no breaks in existing development programming. I can hardly wait for 4.10 to emerge. Dave - -- Dave Laird ([EMAIL PROTECTED]) The Used Kharma Lot / The Phoenix Project Web Page: http://www.kharma.net updated 01/20/2003 Year 2 of running Mandrake Linux workstation on a 100% Microsoft-free system. An automatic & random thought For the Minute: "I'm really enjoying not talking to you ... Let's not talk again ____REAL soon ..." -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+NgagaE1ENZP1A28RArWyAKCXGpqiBzjU3ncLhKgbXXfKIaNKqgCfQAOL +blvRusz2jX7h3UtwOQ7Qrk= =UzOL -----END PGP SIGNATURE-----
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com