Re: Oracle Stored Procedure Performance??

From: Andreas Jung <ajung_at_yetix.sz-sb.de>
Date: 2000/06/27
Message-ID: <51da.39590766.ba838@yetix.sz-sb.de>#1/1

newsiyal <anilsiyalNOanSPAM_at_yahoo.com.invalid> wrote: 2qy
2qyHi,
2qyI would like some advice from DBAs or people who have 2qyimplemented high volume systems. Is it better to use Oracle 2qystored procedures or not to get optimum performance in a high 2qyvolume system or is better to handle the load on the client side 2qy(web servers).
2qyWe are not concerned about portability being an issue.

I think in most cases stored procedure offer better performance when handling lots of data - you need to transport the data through the net.

Andreas Received on Tue Jun 27 2000 - 00:00:00 CDT