Re: Help about ODBC

You might want to do a test with the OpenLink multi tier drivers (http://www.openlinksw.com) and compare that to ESQL/C. For such a test you should do some tuning on installation such as setting similar paramters as the fetch buffer size in the ODBC driver. I also think this driver will utilize the fetch buffer size on the server side in the communication with the engine. Check the 7.3 documentation on how to set it up. As to fetch array I don't know if something similar is supported in these drivers. On Tue, 25 Aug 1998 12:57:36 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >TIWARI SATYENDRA wrote: >> >> Hello everyone, >> >> We have to make a decision whether to use ODBC or direct esql statements >> in a VC++ project (using Informix Db). The main issue is performance. It's >> a semi-realtime type of environment and if using ODBC leads to major >> delays, we wont be able to use it. >> Could anybody elaborate on the topic or direct to the right resources >> so that we can make decision. Appreciate your time. > >I'm cross posting this to comp.databases.informix for you, it is a >better source for Informix questions as only a few of us CDI denizens >also lurk here on CD. > >I suspect that ESQL/C is faster than CLI/ODBC. Also I do not think >that CLI has access to advanced ESQL/C features such as FETCH BUFFER >sizing and the FETCH ARRAY feature which are important to maximize >performance. These 7.xx features are finally documented in the release >notes for 7.30 (see the Informix WEB site if you have an earlier 7 rel). > >Art S. Kagel Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)