Re: Benefits of stored procedures ??

Hi

You can ONLY gain by moving procedures
and functions that access the database off the client. You gain not only by improved perfomance for queries etc. but also by greatly reducing network traffic.

If you check out my web site at
http://members.aol.com/jomarlen
on my Oracle Utilities page you
will find 2 articles I wrote for Oracle
Informant magazine and a paper I
will be presenting next week at the
ODTUG conference in St. Louis.

Between them they should give you a
good insight into how to implement this.

>Hello everybody ,
>
>Does anyone have experience or some details about comparision of using
>stored procedures vs procedures on client side ?
>Running Oracle 7.1.2 on Sun Sparc 20 with 256 RAM,
>clients mostly P133, Winrows 95.
>Idea is to move the code to the server side, but I am not sure is it going
>to be faster, and what price would I pay for it ?
>
>Zoran Kuret
>dELTA d.o.o.
>Tuzla, BiH
>
>
>
>
>
>
>
Received on Fri Oct 31 1997 - 00:00:00 CET