Comparing oci and pro*c performance [message #94016] |
Wed, 03 September 2003 06:40 |
tanzim
Messages: 1 Registered: September 2003
|
Junior Member |
|
|
Hi,
Its obvious from the Oracle Call Interface FAQ [[http://www.orafaq.com/faqoci.htm]] that performance wise, OCI is better and faster that PRO*C. For programmers like me or you its easy to understand; OCI is a direct application to oracle interface, whereas PRO*C is a layer between the application and OCI.
The problem is, one of my friends, who also happen to be an Oracle certified professional thinks that PRO*C's performance is the same as OCI, since PRO*C is also uses OCI! As a reference he gave me this link [[http://technet.oracle.com/tech/oci/content.html]], where it says that "Every interface to Oracle goes through OCI. These include: PL/SQL applications executing SQL statements Pro*C applications etc."
So, I ask you gurus, to validate whether its true, i.e. PRO*C is as good as OCI in terms of performance, in all cases.
Thanks.
|
|
|