Re: 4GL Prepare vs Stored Procedure ?

belakimem@aol.com (Belakimem) wrote: :Hi all : :Suppose I 4GL prepare an insert, or select say. : :Suppose I have a stored procedure which does the same thing. ( The :execution of which I realise I need to Prepare ). : :Is it faster, slower, the same, to use the 4GL prepared insert or call the :stored procedure? I am quite sure that an 4GL prepared insert will be faster than inserting via a stored procedure. Simply think about what have to be done at runtime in these two cases. The same is true for a simple select. Generally you use stored procedure only when some amount of processing has to be done. It is most efficient in a client/server situation to avoid shipping large amounts of data across a network. :Potential responders, please reply to my email address as well as the :Newsgroup. Thank You. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org