Re: Re[2]: Is Informix Reliable?

Craig.Lanford@alltel.com wrote: > >What are some examples of the optimizer taking bad paths? Just curious >because we upgraded to 7.23 and I want to know what to look out for. >Craig Laford >Mailto:craig.lanford@alltel.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 > > I've never lost data with informix, I've just lost capablilties with updates and upgrades! In 1994, I gave up on informix because the installed systems where unpredictable. Terminals locking up. Reports not running on certain dates. Reports that ran perfectly on older informix version didn't work anymore on newer versions. TSS space (temporary string storage) area was too small and poorly managed - which caused errors when manipulating string data. I require only a handful of things in a language. Chief among these is trustworthyness, and consistency. So, why do I watch this ng? because I keep hoping that informix will become worthy again. I have stacks of code for a manufacturing system that I can't sell because I don't trust the language! I would _LOVE_ to trust informix again. (I'm not holding my breath) dave