Re: Is Informix Reliable?

My favourite SE story was when I walked into a cellular service provider who was complaining about bad month-end run performance on their multi-gigabyte (+-30GB) database. I had my copy of the OnLine 7 performance tuning guide in my briefcase and ready to rock. Imagine my surprise when I found out they weren't running OnLine anything! And they had individual .dat and .idx files in excess if 1GB... What is a recurring problem, in my experience, is index corruption; however, bcheck has always fixed this. It's also generally easy to spot! :-) On 26 Jan 98 at 16:08, Steven L Cooper wrote: } I have NOT had any problems with SE. We use SE on our development } box and run OWS on the runtime system. Both of these systems have } be rock solid for the last 6 months. FWIW flaky hardware can cause } software to look bad... } Kevin Patten <patten@nospam.flclerks.com> wrote in article } <34c89ee0.0@webserver.flclerks.com>... } > We have found the SE product to be unreliable!!!! Screwed up } > indexes, inaccurate row counts.... However, the Online version } > (7.2x) has been } very } > reliable from a data integrity standpoint. } > The optimizer is psychotic, however there are workarounds. } > Warren Zeigler wrote in message } > <6a8n1h$k76$1@news.xmission.com>... } > >I am currently evaluating Informix -vs- Oracle, and would } > >appreciate } your } > >input. } > > } > >I have read on a few threads that people have had to unload and } re-install } > >the database to fix corrupted system tables, indexes, etc.. How } > >often } does } > >this happen? } > > } > >Also, how reliable is Informix in client/server code, as compared } > >to } > running } > >code on the same machine as the server? Are hung sessions rare or } frequent? } > >I need sessions to be able to stay up between middleware servers } > >and the Informix server for months at a time. } > > } > >Thanks } > > } > > } > } > } > } -- /Ciao, \\Billy / \\Group Managing Director, The West Solutions Group: http://www.west.co.za / Chairman, South African Informix User Group: http://www.west.co.za/~saiug \\ Informix FAQ @ http://www.iiug.org/techinfo/faq/faq_top.html / Drivel @ http://www.west.co.za/tasteless/ \\________________________________________________________________________________________________