Re: Future of Informix 5?

Michael Segel <"MailerDaemon"@[127.0.0.1]> wrote in article <64i2s0$ln0@argentina.earthlink.net>... > <snip> > Why anyone would be hesitant to move to 7.x is beyond me. > 7.x has been around for over 2 years in major release and is > fairly stable. > > As far as the complexities in tuning, please remember that you don't > have to fine tune an engine unless you really need that extra 5% > performance gain. > <snip> Why not upgrade from 5 to 7? From what I've seen if you are running on a uni-processor machine version 7 can not be tuned to provide good OLTP performance while any large queries/reports are running. Informix 7 will often complete the large queries/reports quicker, but only at the expense of the OLTP users. In many environments this is not acceptable. For all its faults, Informix 5's method of running each user session a separate process (rather than thread) allows the OS to pre-emptively multitask the database sessions and provide for more level performance when both OLTP and DSS type queries are going on. Now if there was some way to tune 7 to not behave this way... some way of controlling a sessions priority (other than PDQPRIORITY) perhaps? -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com