Re: Which one faster?

Many posts ago, i.sokolsky@geac.com[SMTP:i.sokolsky@geac.com] wrote: > > > > > > > > > > 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? Personally, I'm amazed that with all the erudite and intelligent people who have replied to this question, no-one has suggested a benchmark or clearly offered the opinion that stored procedures may not be faster in all circumstances than an executable. May I do so now... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com