Pro*C Prepared SQL

From: Steve T. Tran <sttran_at_owlnet.rice.edu>
Date: Sat, 10 Apr 1993 00:07:00 GMT
Message-ID: <C58qzo.2A6_at_rice.edu>


Hi all (I'm posting for a friend),

He writes:

I'm in the process of porting a C program from Informix ESQL/C (actually Plexus, but that's another story...:-)) to Oracle 7 Pro*C. One performance enhancement done to the original program was to "pre-prepare" all static SQL at the beginning at the program and not freeing them until the program quits. By pushing all the prepares to the top, ESQL/C doesn't have to compile a reused SQL query everytime it's used. Scope for ESQL/C prepared SQL identifiers is in the module of the program (rather than the function).

My question is: does Pro*C treat prepared SQL the same way? I am wondering if I can get the same win in Pro*C as the original programmer did in ESQL/C.

(BTW - I'm using Oracle 7.0.12 on a HP H30 - aka 9000/847) Received on Sat Apr 10 1993 - 02:07:00 CEST

Original text of this message