Re: Q: Is there an usable ODBC driver for Informix 5?

vedran.mornar@fer.hr (Vedran Mornar) writes: > We have tried Q+E Informix 5 ODBC driver which comes with New Era 1.0, and it > was unacceptably slow in VB app. We were using PC NFS 5.1a on Win 3.11 to a > SUN server. > > To execute a select * from table which had > 1 record it took 2 seconds or more. With some API calls to the same server the > same select was executed and data fetched in a fraction of the second. > > Does anybody have better experience with ODBC + Informix? > > I'm using Informix 5 on a 486 66 with 64 meg ram and SCO Unix Ver 4.2. On the client side I have Access V2 runing on a Pentuim 90 with 16 meg ram. I'm also using the Intersolve drivers (the bought Q+E awhile back). With a correctly structured query against a table with aprox 1 million rows I receive acceptable proformance. ( will under a minute to return a few hundred rows) What version of ODBC drivers are you using? What is your client PC set up? What network connects the two machines? How does the system respond to the utiliy than Informix ships with there client software. (I'm at home and don't remember the name but it logs into your server and displays the sample database usually located in the root dbspace) Steve