Re: Why Not MySQL?

At 11:44 AM 5/3/00 -0300, The Hermit Hacker wrote:

>My experience so far is that it was basically a 'plug-n-play' sort of
>thing ... dump your database, upgrade and reload ... the only problem I
>had was one script that I did something like:
>
>SELECT field as field

I was able to dump my birdnotes.net database and reload it without change,
if another datapoint will help your boss's confidence level.

>without realizing it, and v7.0 won't allow that (field == field) ... other
>then that, *much* more stable, and appears faster then the old ...

My system had one query in particular that suffered from a poor
plan (a very bad nested loop), the changes to the optimizer have
resulted in a much better plan in 7.0 which just flies.  I've been
very happy with 7.0.

Tell your boss we're smarter than he is and switch :)



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.