>>>>> "CM" == Carlos Moreno <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
