Re: Informix 5 vs. 7

Ofer Inbar wrote: > I've arrived at a new site where they plan to start using Informix > OnLine for the first time. I asked what version they bought, and they > > said 5! They got it because it was cheaper. I've never worked with 5 > > and am wondering if it makes any sense for a brand new installation to > > go with 5 instead of 7? What are some of the advantages of getting 7? > > -- Cos (Ofer Inbar) -- cos@leftbank.com cos@cs.brandeis.edu > > -- The Left Bank Operation -- lbo@leftbank.com > http://www.leftbank.com/ > "GUIs normally make it simple to accomplish simple actions and > impossible to > accomplish complex actions." --Doug Gwyn (22/Jun/91 in > comp.unix.wizards) Hi there I'm trying to decide wether to upgrade from 4 to 5 or 4 to 7 (SE) If you get any info I would be most interested. If I find any out I'll contact you. 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 7 will also be supported for longer than 5 (or 4 in my case which is currently unsupported by informix) Also moving directly to 7 means you don't have to migrate via 5 & 6 etc. I hope this useful, If you get any better info please let me know. Many thanks