Re: Benefits of stored procedures ??

Zoran Kuret wrote:

> Does anyone have experience or some details about comparision of using
> stored procedures vs procedures on client side ?
> 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 ?

Server side stored procedures will always outperform client side code as they eliminate network traffic which is usually the most time-consuming part of a transaction. I have experienced performance benefits of 100's of % by replacing client side code with stored produres.

The only cost's will be those involved in developing the stored procedures. These will be minimal (assuming you have the Oracle expertise) for a new application, however it can be quite costly if you need to re-engineer an existing client application to move some processing to the server.

One other drawback, is that by making an application reliant on Oracle stored procedures that application will only run on an Oracle Database. Most readers of this newsgroup (myself included) will probably think that this is not a bad thing, however it could cause you problems if you are trying to develop an application to run on many different vendors RDBMS's.

Hope this helps,

Ian Received on Mon Nov 03 1997 - 00:00:00 CET