RE: Which one faster?

Posted in 1999

Irineu Rocha — Fri, 23 Jul 1999 16:06:21 -0300 — source: Informix-list mailing list archive (1991-1998)

Stored procedures are faster than other ones. SISGRAPH Irineu Tachinardi Rocha AIM Group - Sisgraph (Intergraph Brazil) System Analyst Email: irineu@sisgraph.com.br Phone: 55-11-8892058 Fax: 55-11-8877763 http://www.sisgraph.com.br > ---------- > From: i.sokolsky@geac.com[SMTP:i.sokolsky@geac.com] > Reply To: i.sokolsky@geac.com > Sent: Friday, July 23, 1999 2:31 PM > To: informix-list@iiug.org > Subject: Which one faster? > > Hi > > 1.Is there a difference in the speed between Stored Procedure and C > executable that execute same sql statments? > > 2.What will give faster result Client (VB) ,which executes sql code, > or if a client will execute a stored procedure on a server? > > Regards > > > Igor >

↪ replying to Irineu Rocha

Paul Wilson — Fri, 23 Jul 1999 23:42:32 +0100 — source: Informix-list mailing list archive (1991-1998)

But as database changes.. remember to update the statistics for the stored procedure... otherwise optimizer plan will be out of date! Irineu Rocha <irineu@sisgraph.com.br> wrote in message news:7naevo$s11$1@news.xmission.com... > > Stored procedures are faster than other ones. > > SISGRAPH > Irineu Tachinardi Rocha > AIM Group - Sisgraph (Intergraph Brazil) > System Analyst > Email: irineu@sisgraph.com.br > Phone: 55-11-8892058 Fax: 55-11-8877763 > http://www.sisgraph.com.br > > > > ---------- > > From: i.sokolsky@geac.com[SMTP:i.sokolsky@geac.com] > > Reply To: i.sokolsky@geac.com > > Sent: Friday, July 23, 1999 2:31 PM > > To: informix-list@iiug.org > > Subject: Which one faster? > > > > Hi > > > > 1.Is there a difference in the speed between Stored Procedure and C > > executable that execute same sql statments? > > > > 2.What will give faster result Client (VB) ,which executes sql code, > > or if a client will execute a stored procedure on a server? > > > > Regards > > > > > > Igor > >