Re: Insert cursors?

---- you wrote: > 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? Yes there is Dude, sqlca.sqlerrd[3], but perhaps the Clown Dude means you just have a count, and not the actual lost records. Unless you write code to store up all inserted records, and retry them when the count doesn't match, or log them. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com