Re: Fastest: Embedded SQL or OCI ?

From: Guy Dallaire <dallaire_at_megatoon.com>
Date: 1996/02/25
Message-ID: <4go3ft$h0q_at_news.accent.net>#1/1


hage_at_telepost.no (Erik Hage) wrote:

>Any info appreciated:
 

>Does anybody know which of the two is the fastest:
>Embedded SQL or OCI? (using Windows 3.11).
 

>bjorn-tore.dale_at_merkantildata.no (Bjoern-Tore Dale)

If by "Embedded SQL" you mean PRO*C with embedded SQL, I don't think that OCI is faster than that. In fact, the PRO*C preprocessor basically transforms your PRO*C code to something that closely ressembles C code with OCI calls.

I coded with both PRO*C and OCI on Windows and I preffered OCI. It's a little more work, less portable, but man, I hate to have to go to DOS to compile a Windows Executable ! Their PRO*C product for Windows doesn't even RUN on windows.... I think the new release is supposed to work.

If on the other hand, you mean "PL/SQL", you better use OCI, unless you stick with sohort functions that don't get called too often...

                        Hope this helps Received on Sun Feb 25 1996 - 00:00:00 CET

Original text of this message