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

  • From: Robert Eskridge <bryny@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 5 May 2004 15:31:48 -0500

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: