Re: Upgrading from 7.2.3 to....??

>>>>> "CM" == Carlos Moreno <moreno(at)mochima(dot)com> writes:

CM> What would be your advice? Is 7.3.4 the recommended one
CM> if we need reliability? Or has 7.4 earned sufficient
CM> trust by now?

CM> Also, how about back compatibility? Should I expect some
CM> trouble? I remember with one of the previous upgrades

I just did that switch from 7.2 over to 7.4 this past weekend. It
went very smoothly. The major things to watch for that I found in the
history/release notes which were not very obvious were:

1) implicit converstion of empty string to numeric 0 is no longer
there. be sure you either specify numeric 0 or string '0' when you
mean that.

2) if you have default 'NOW()' (in quotes!) you have to change that to
default NOW() without quotes. Similar for other date/time default
thingies.

3) 7.2 used to nicely order your group by's implicitly. this is no
longer the case -- you must explicitly list any ordering you wish
imposed on group by's.

I think that was it. The speed seems to be faster, but that could
also be due to moving from a 4-disk RAID10 to a 14 disk RAID5 with
faster spindles ;-)

This is running my production site which does a *lot* of
inserts/updates daily. I'm very happy with it. You will be to :-)

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/