Re: Which is faster (stored procedure or insert statement)?

Posted in 2003

Jack Parker — Mon, 5 May 2003 17:13:38 -0400 — source: Usenet: comp.databases.informix

Especially if you use an insert cursor. cheers j. ----- Original Message ----- From: "rkusenet" <rkusenet@sympatico.ca> To: <informix-list@iiug.org> Sent: Monday, May 05, 2003 1:59 PM Subject: Re: Which is faster (stored procedure or insert statement)? > > "Dragan Gajic" <gdraganyu@yahoo.com> wrote in message > news:98b9be37.0305050953.179b01a9@posting.google.com... > > Hello, > > > > I have an ESQL/C application that parse large files and import data to > > one table (~1500000 records per file). Currently I have one stored > > procedure that do insert (for each parsed record I call that procedure > > from ESQL/C with execute procedure statement). Would it be faster to > > do that without stored procedure, with insert statement from ESQL/C? > > (Informix 9.21 on HP-UX 11.0) > > ESQL/C will be faster by an order of magnitude. > > > >