Pro*C and stored procedure preformance

From: Nick Jost <nickjost_at_ix.netcom.com>
Date: 1995/08/03
Message-ID: <3vr35j$sr7_at_ixnews3.ix.netcom.com>#1/1

Currently I have sql statements in a Pro*C program I am working on. One of my co-workers suggested that I use stored procedures to increase preformance. My question is, does it?

I figured that the SQL, once the Pro*C was compiled, was in it's tightest form hence a function call would only slow things down. Has anyone done trials on this showing a net difference one way or the other?

Nicholas Jost
Programmer/Analyst RxNet Received on Thu Aug 03 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Peter Constantinou: "HELP: Info about ORACLE7 Performance on RAID"
Previous message: Erika Hooker: "Forms 4.5 and SQL*Net"
Next in thread: Mark Grand: "Re: Pro*C and stored procedure preformance"
Reply: Cal Wooten: "Re: [Q]. Installing ORACLE7 on Solaris 2.4"
Reply: Mark Grand: "Re: Pro*C and stored procedure preformance"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message