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
Serviceand other goodies at http://donb.photo.net.