Re: insert cursors

On Tue, Feb 12, 2013 at 12: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. > The speed-up available depends on a variety of factors. One is the buffer sizes used (FET_BUF_SIZE etc); another is the size of the rows you're inserting; another is the distance of the Informix data server from the client application (the longer the network connection, the more benefit you get); another is the way you use the cursor (using FLUSH after each PUT partially defeats the benefit of using an insert cursor at all). Data types can affect this too; if there are blobs involved, then the insert cursor operates one row at a time, IIRC. > *From:* informix-list-bounces@iiug.org *On Behalf Of *Jonathan Leffler > *Sent:* Tuesday, February 12, 2013 10:54 AM > *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."