Re: PRO*C or Stored procedure, which one faster ?
From: Bruno S Fernandes <bruno-s-fernandes_at_telecom.pt>
Date: Fri, 22 Jan 1999 18:05:23 -0000
Message-ID: <78ael6$cbu$1_at_pthp35.telecom.pt>
Date: Fri, 22 Jan 1999 18:05:23 -0000
Message-ID: <78ael6$cbu$1_at_pthp35.telecom.pt>
If the process you want to execute is very complex and involves a considerable amount of data i would advise you to use Pro*C, because like this you're process is an executable file (interpreted and compiled) that you can run in background on your server. If you use a stored procedure (PL-SQL) it is much easier to develop but in terms of execution it's not so good. When you invoque the stored procedure from the forms, PL-SQL contained is going to be interpreted therefore taking more time to execute and holding the client form until it terminates its execution. Received on Fri Jan 22 1999 - 19:05:23 CET