Re: Benefits of stored procedures ??

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1997/11/01
Message-ID: <346c87d7.33452002_at_netnews.worldnet.att.net>#1/1


On 31 Oct 1997 17:07:29 GMT, "Zoran Kuret" <delta_at_k2.net> wrote:

>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 ?

Want my two cents? I usually try to minimize network traffic. If I can process a lot of data on the server and avoid bringing it down to the PC, than great. On the other hand, if I'm bringing all the data down to the PC anyway, I might chose to do any additional processing there.

and sometimes I just do what's expedient.

Jonathan Gennick



gennick_at_worldnet.att.net
http://home.att.net/~gennick Received on Sat Nov 01 1997 - 00:00:00 CET

Original text of this message