Oninit cdi / Archive
Talk to an expert →

Insert cursors?

Posted in 2000

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

strangiato@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

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? Thanks :) Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to strangiato@my-deja.com
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Much quicker. In article <8i36hv$dd6$1@nnrp1.deja.com>, strangiato@my-deja.com wrote: > 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? > > Thanks :) > > Sent via Deja.com http://www.deja.com/ > Before you buy. > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary