Re: Move 4 to 5 or 4 to 7

On Tue, 12 Aug 1997, Alastair Kimbell wrote: > I'm trying to decide wether to upgrade from 4 to 5 or 4 to 7 (SE) I'd suggest 7 all things being equal, as it is more likely to evolve. > If you get any info I would be most interested. If I find any out I'll > contact you. Don't worry about it :) > What I have found so far is that 7 has a new cost based optimiser that > can > speed up queries : more sophisticated than the old update statistics in > that it takes into > account data distribution etc Not entirely true. While the new optimizer can make ome better index choices, if you are not currently having optimizer problems I doubt you'll see a speed improvement there. The new optimizer is nice, though. > 7 will also be supported for longer than 5 (or 4 in my case which is > currently unsupported by informix) I'd say that this would be my main reason to recommend 7. -Richard