Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Alex Fiore — — source: Informix-list mailing list archive (1991-1998)
Vedran Mornar wrote:
>
> 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 do. I have used the driver that you mention. Tests I have
run using straight C code using both ESQL/C and the Q+E
driver show that the ODBC drive only takes about 5-10% longer
to complete tasks then ESQL/C alone. The tests I run include
INSERTing 1000 rows, retrieving 1000 rows, and updating 1000
rows.
My experiece with with Visual C++'s CRecordSet classes show
that there is a lot of overhead associated with MFC's wrapper
around ODBC. Possibly you are running into the same thing with
Visual Basic.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.