Cache OCI Calls to Improve Performance of 32-Bit or 64-Bit Oracle Clients

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Wed, 5 May 2004 15:31:48 -0500
Message-ID: <2100407343.20040505153148@dfweahs.net>

This paper seems to have a likely explanation for a sudden performance hit when developers did a 10x number of calls to the database in an application (most calls return 0 rows).

http://developers.sun.com/solaris/articles/oci_cache.html#4

Has anyone compiled this with gcc and used it? I'm slogging through rewriting the c64.sh script to get it going but if anyone else has done it already I'd be happy to take a shortcut....

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 05 2004 - 15:30:17 CDT