From: clement1@llnl.gov (David Clement)
Newsgroups: comp.databases.oracle
Subject: Re: Embedded SQL vs OCI
Followup-To: comp.databases.oracle
Date: 2 Feb 1994 20:24:41 GMT
Organization: Lawrence Livermore National Lab
Lines: 22
Distribution: world
Message-ID: <clement1-020294122849@attilla.llnl.gov>
References: <2ioepe$ke3@meaddata.meaddata.com>
NNTP-Posting-Host: attilla.llnl.gov


In article <2ioepe$ke3@meaddata.meaddata.com>, darin@meaddata.com (Darin
McBeath) wrote:
> 
> I am beginning to write applications in Oracle and have a very simple	
> question.  In terms of performance, is it better to write a C application
> in embedded SQL or OCI.
> 
> Thanks.

The question has been addressed before in this newsgroup. The consensus
seemed to be in favor of OCI, so far as I could tell.

Reasons mentioned, aside from performance, were:
 - size of resulting executable (OCI was said to be smaller);
 - maintainability of code (Pro*C generates a .c source file, intermediate
between the .pc and the .o, which greatly complicates debugging, for
example)
  
______________________________________________________________________
David Clement       ||  Geyr Garmr mjok fyr Gnipahellu.
clement1@llnl.gov   ||  Festr mun slitna, enn freki renna. 
______________________________________________________________________