Re: Which is Faster ? CALL or RUN PROGRAM

Appala.Naidu@KSNCABP03.SNSGATE.sprint.com wrote: > > > Hi, > > I have a program and I would like to invoke it as a CALL > function. For that I have to make a considerable change in my > Code. I can invoke it as a RUN PROGRAM without making any changes. > For efficiency and Response Purposes, which one is better? > Calling as a Function or Calling as a RUN PROGRAM and for what reasons. > CALL will always be faster than RUN, because RUN will open the database again, and memory has to be allocated for the new process(es). I think the only reasons to use RUN instead of CALL would be if you wanted to run a seperate process without waiting for it to finish ("RUN ... WITHOUT WAITING), or because the parent program is getting so big you don't want to increase its size by adding the new code to it. //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer