Re: insert cursors

One thing that makes a big difference when using insert cursors is to increase the size of the buffer that the cursor uses. You can do this by exporting the environment variable FET_BUF_SIZE in the task's environment and setting it to a larger buffer. The default is 4096 and the maximum is 65530. I am assuming that you are not forcing a flush of the cursor after each PUT but are allowing the cursor to flush itself only when the buffer fills. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Feb 12, 2013 at 3:54 PM, Randall Young (ADE) < Randall.Young@arkansas.gov> wrote: > Thanks for your prompt response. I did manage to get the insert cursor > working under 4GL. Unfortunately, it didn’t seem to increase the speed on > the insert. The last time I tried this method was in late 1990s. Perhaps > the hardware and the storage devices are much faster these days. Thanks > for you help.**** > > ** ** > > --**** > > Randall Young**** > > randall.young@arkansas.gov**** > > ** ** > > “Blessed are we who can laugh at our surroundings for we shall never be > considered completely sane.”**** > > ** ** > > *From:* informix-list-bounces@iiug.org [mailto: > informix-list-bounces@iiug.org] *On Behalf Of *Jonathan Leffler > *Sent:* Tuesday, February 12, 2013 10:54 AM > *To:* Randall Young (ADE) > *Cc:* Informix List - IIUG > *Subject:* Re: insert cursors**** > > ** ** > > ** ** > > On Tue, Feb 12, 2013 at 7:26 AM, Randall Young (ADE) < > Randall.Young@arkansas.gov> wrote:**** > > I have had some good experience with insert cursors in esql/c. The > documentation seems to say that I cannot use this feature in 4GL. Is there > some analogous way to speed up inserts in 4GL? **** > > **** > > IBM INFORMIX-4GL Version 7.50.FC5**** > > DB-Access Version 11.50.FC5**** > > > > INSERT cursors were added to I4GL at the time they were introduced in > ESQL/C, way back in the distant mists of time (circa 1988). They should > still be supported. Any documentation to the contrary needs to be > reported, please, so we can get it fixed. > > -- **** > > Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> > Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org > "Blessed are we who can laugh at ourselves, for we shall never cease to be > amused." **** > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >