Re: Which one faster?

Posted in 1999

Richard Auslander — Fri, 23 Jul 1999 15:48:24 -0700 — source: Informix-list mailing list archive (1991-1998)

Yes, the stored procedure can be substantially faster since, as a stored procedure, it is pre-parsed and pre-compiled. Igor wrote: > 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 -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com