Re: How to set insert cursor buffer size in Informix 7 ?

Art S. Kagel wrote: > > Martyn Barry wrote: > > In an ESQL/C program define the extern: > > extern short FetBufSize > > The default is 4096 you can increase this but not decrease it: > > FetBufSize=8096; > > This is available beginning with 6.0 and is used for all cursors > according to an Informix Document I have. I presume that includes > insert cursors. You should be able to do this through a C wrapper in > 4GL as well. In other tools it may not be possible. Vers 7.22 has an > sqlhosts optional parameter to set the size of the network > communications buffer which will affect performance of this increased > data buffer. Check the docs. The environment variable is FET_BUF_SIZE. But as far as I know, it doesn't get used by 4GL. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+