Re: Fastest: Embedded SQL or OCI ?
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