Pro*C Prepared SQL
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