Re: Informix left standing

In article <6dqmc5$mo5$1@picasso.op.net>, root@candle.pha.pa.us writes >Steven Hauser <hause011@garnet.tc.umn.edu> wrote: >: The move of the HP, SUN and IBM/AIX to SMP architectures was an obvious >: factor in the success of Informix 6.x and 7.x product. It allowed >: performance to scale. The fact that from the app there was no way >: to tell the number of real cpu on a machine ment no change to the >: way of doing business, another advantage in the acceptance of the >: product. Oracle still does not scale well on multiple CPU arch. > >Success of version 6.x? From what I heard, many people left version 6 >to return to version 5 because 6.x was so buggy. And version 7.x was True, but remember it was a full engine rewrite... >buggy for perhaps 18 months after release, slower, crashing and choking >on simple queries. And I think version 5 is still faster on single-cpu No really, it was usually things like joins to remote tables or tables in another database, and parallel queries that had problems. Simple queries in one database tended to be ok. >machines that 7.x. Remember the NewEra failure to catch on, no 4GL 7.x is faster than 5 even on single CPU machines. CPU is rarely a bottleneck on database servers, usually disk I/O is the problem. >language enhancements, and the non-port of 4GL to NT. > >So UDS, or whatever they are calling it today, is not the first problem >Informix has had. Since version 5, it looks like things have pretty >much headed south for them. > >It is not that I don't like Informix, because I do, but historical >perspective shows they have not really hit any home runs lately. > I'd say 7.x I now a home run.... -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care