Re: Insert cursors?

From: Heiko Giesselmann <heiko.giesselmann@informix.com> > >Obnoxio The Clown wrote: > > > From: strangiato@my-deja.com > > > > > >Online 7.x Informix 4gl > > > > > >I have a 4gl app which inserts 7.5 million rows into a table as a >result > > >of the main foreach looping that many times. My inserts are PREPAREed > > >but singleton. Could the insert be slowing me down? I've never used > > >insert cursors are they quicker? > > > > Buffered cursors can be very fast indeed, but you have a problem if a >row > > fails for some reason. You then lose the contents of the buffer, and you > > can't really tell what you've lost. But if your data is clean, it'll >fly. > >I am pretty ignorant about 4gl, but isn't there something equivalent to >sqlca.sqlerrd[2] in ESQL/C to allow you to determine for each PUT how many >rows >have been successfully shipped and inserted? Picky, picky, yes the whole SQLCA structure is available, but it's a lot of complicated work to undo a buffer or part thereof. Probably not complicated to people who write (say) fancy benchmarks for a living, but certainly for dumb clowns... :0) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com