Re: Informix left standing

David Williams wrote: > > 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.... Hmm, it still has a bug in the AVG when grouping by large groups including nulls up to version 7.3 (I was told - I had it in 7.12). Tech support's attempt to fix that for me with a patch gave me another bug where stored procedures locked themselves solid. Is everyone descending to the level of Microsoft now: let the users debug it? > > -- > 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 -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.