Re: PRO*C or Stored procedure, which one faster ?
Date: Sat, 23 Jan 1999 20:46:25 -0800
Message-ID: <36AAA5A0.6F8A64D5_at_u.washington.edu>
[Quoted] Generally the stored procedures are the fastest --they use the internals of Oracle, etc. There are 2 (or more??) significant drawback to stored procedures. First the data is difficult to get out of the database and into other programs. Obviously there are mechanism, but it is harder. [Quoted] The second is the level of "security" on your system. Often the dba does not allow the introduction and modifications of SP without review, validation, etc. If you are doing ad hoc or prototype or rapid development work, this would be a problem.
[Quoted] ProC has advantages on manipulation of data, more complete procedural constructs, etc.
Mike Krolewski
samshi wrote:
> Hi ,
>
> Not considering the Client side , just talking in a huge central
> database env .
>
> thanks in advance .
>
> Sam
Received on Sun Jan 24 1999 - 05:46:25 CET