-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Good evening, Benjamin...
On Monday 27 January 2003 06:11 pm, Benjamin Pflugmann wrote: > How about > > http://www.eweek.com/article2/0,3959,293,00.asp > which tests MySQL 4.0.1 and MySQL AB's summary of the latter: > > http://www.mysql.com/eweek/index.html > > Unfortuneatly, neither PostgreSQL nor a MySQL 3.23 was not part of the > test. Yes, but even *I*, a totally convinced user of MySQL over Micro$oft's best, sat there reading both articles and warbling like a jaybird who's got his b**ls caught in an electric fence! That is impressive news indeed! I was going to send both these articles to a certain Mickey$oft SQL admin-type I know, but I understand over last weekend he was unexpectedly busy for three days in succession. Something about an upgrade or a patch, I was told. 8-) > [...] > > > Looking forward to seeing it. So the MySQL team considers 4.x stable > > now? Do they recommend using it over 3.x? > > According to http://www.mysql.com/downloads/index.html still 3.23.x is > recommended, but from what I know, that probably changes with the next > release (see below). > > On Mon 2003-01-27 at 11:55:56 -0700, [EMAIL PROTECTED] wrote: > > On Sun Jan 26, 2003 at 09:10:12PM -0800, Dave Laird wrote: > > [...] > > > > The last time I looked (last week or two) it was listed as > > > BETA-Stable, > > That would be rather be at least 6 weeks, because since 2002-12-14 > (v4.0.6) MySQL is declared gamma. That's about right, actually. I was going to check back, to see if the development status had changed in the interim, but didn't. Shame on me. I updated my version to the Gamma 4.0.6 earlier this evening and will be testing it on my development box tonight. If it was good enough to compete nose-to-nose with Micro$oft and win, it's probably good enough for my development machine, IMHO. 8-) > > > but other than having to regenerate the indexes for an existing > > > table which I moved over into my development directories, it was > > > pretty much a bolt-up application. > > I am not sure why you *had* to rebuild indexes. AFAIK, MySQL 4.0.x > should work on tables created with 3.23.x (aveats below ;) I'm relatively certain that was an anomaly that came from the tarball I used to copy the files over, rather than something wrong with the indexes themselves or the method which 4.0.x reads and writes to them. I tried replicating the original error just now with the Gamma release and the problem didn't reoccur. However the access speeds of selecting a single record in the 100,000 record database is impressive. Once the selected record is in the cache, selecting it a second time is *blinding*. > According to the 4.0.8 release note, the next version is expected to > be declared stable. Since 4.0.9 was released two days later to fix > some screw-up that slipped by, 4.0.10 is generally thought to be > released as stable, if nothing unexpected happens. Kewl! I can hardly wait! > The short story is that 4.0.x should work out-of-the-box on a 3.23.x > database and configuration, but you will have to do some tweaking in > order to be able to make full use of the new version. Tongue-in-cheek rules to remember when testing the Gamma: 1. Wear a hair net to hold your hair in place. There are recorded instances of people being plucked bald by the sheer speed of the newest releases using the cache. 2. Avoid any and all discussions relating to the "vast superiority" of Microsoft SQL over MySQL like the plague. Maybe if we keep this really quiet Bill Gates won't try and buy MySQL. 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: Yow! It's some people inside the wall! This is better than mopping! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+NfK8aE1ENZP1A28RAkc4AJ49CHhVHHgh62+lsrmfj7xehnSMnwCeMOhj oZO1g2ho1Yb7X/yf1A345T0= =Qwis -----END PGP SIGNATURE-----
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
