Re: Fastest: Embedded SQL or OCI ?

Young_Charles <cyoung> wrote:

>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)
 

>My experience is that the OCI routines are about 50% faster than embedded
>SQL, using C and C++ on various Unix boxes. The primary reason for this,
>as far as I can tell, is that the OCI routines are written in assembly(!).
>I don't know if this holds true for Windows or any other non-Unix platform.
 

>Chip

Chip is wright, it is much faster. But the reason is much more because of the code generated by Pro*C, it's enormous. For each SQL statement, Pro*C will generate huge amount of variable space and from one statement to the next, will not reuse the space of the previous statement. Received on Fri Mar 01 1996 - 00:00:00 CET