Re: Performance difference between EXEC SQL and Stored Procedures

From: David Sisk <davesisk_at_ipass.net>
Date: Tue, 27 Jul 1999 21:19:17 -0400
Message-ID: <YKsn3.118$tp2.54@news.ipass.net>

Hi:

Stored procedures will typically give better performance if they can be used in such a way that network round-trips are significantly reduced. You may or may not be able to accomplish the same thing with Pro*C, though.

Good luck!

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

achd_at_my-deja.com wrote in message <7njmo0$nk6$1_at_nnrp1.deja.com>...
>Hello,
>
>Can anyone advisme me if it is usefull to start using Stored Procedures
>instead of the normal EXEC SQL statements we are now using. Our product
>is written in C/C++ and runs on HP-UX/AIX etc. We use a 8.0.4 Oracle
>database. Would there be a big difference in performance? What are the
>general advantages of Stored Procedures?
>
>Regards,
>
>Douwe
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jul 27 1999 - 20:19:17 CDT