Re: Informix vs. Oracle

This is a multi-part message in MIME format. --------------2901C518E4560D36F697A2E4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit An almost impossible question. In general I like the engine, it is reasonably easy to monitor and debug engine level issues (onstat is your friend). The traditional client API (ESQL/C) is horrid, and like every other RDBMS there are some really dumb things that they do. One example is as a client you can't get access to the execution plan, as it is placed either on the server, or I think with one of the newer releases you can specify a directory. If you are a remote client connecting via say JDBC you can't get the info. (Sybase reports it back in the SQLWarning, and with Oracle you can specify a table to put the plan into) As far as JDBC Drivers, you have to check out Weblogic's Type 4 (pure Java) driver. We have been working with Informix and Java/JDBC connectivity for the last two and a half years, this is the first driver that works well. Good luck, Dirk Fromhein http://www.watershed.com Creators of the Relational Object Framework, Enterprise Object Oriented RDMBS access solutions and services. Ruiming Chen wrote: > Tim Schaefer wrote: > > > Nibblus wrote: > > > > > > Can anyone give me a non-commercial comparison of Informix versus Oracle? > > > > > > Arvid Claassen, last year computer sciences at Antwerp University > > > > There is no comparison. Oracle is a bucket of bolts, old technology, > > band-aids, and wired together into a hodgepodge of junk. > > > > Informix is simply better, with newer technology, scalable, and faster > > than Oracle, especially with regards to data warehousing. > > > > I have worked in Oracle and Sybase environment before. Now I have to work in > Informix environment. But I now nothing about Informix. Please tell me where > to start learning about Informix. > > Thanks! > > Oh, BTW, can anyone can recommand a good JDBC drive for Informix? > > -- > RC Square Team. > --------------2901C518E4560D36F697A2E4 Content-Type: text/x-vcard; charset=us-ascii; name="dpf.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Dirk P. Fromhein Content-Disposition: attachment; filename="dpf.vcf" begin:vcard n:Fromhein;Dirk P. x-mozilla-html:FALSE org:Watershed Technologies, Inc. adr:;;;Framingham;MA;01701;USA version:2.1 email;internet:Dirk.Fromhein@watershed.com title:CTO/President note:http://www.watershed.com info@watershed.com x-mozilla-cpt:;0 fn:Dirk P. Fromhein end:vcard --------------2901C518E4560D36F697A2E4--