Oracle interface (SQL, OCI, etc.)

From: Curt Ingram <cingramb_at_bigfoot.com>
Date: Fri, 24 Mar 2000 01:11:56 GMT
Message-ID: <whzC4.86$ty2.38592_at_newsread2.prod.itd.earthlink.net>



[Quoted] We would like to port an application which previously interfaced with a Faircom C-Tree database to an Oracle backend. The conversion is complete and everything works well but performance is extremely poor. The reason is [Quoted] [Quoted] because reads and writes on individual records in C-Tree are very efficient [Quoted] [Quoted] whereas with Oracle they are not. The application repeatedly reads a single record, updates it and then reads another, etc. I would rather not rewrite [Quoted] [Quoted] the application code so my question is, is there an interface to Oracle which would operate on individual records more quickly than SQL. I seem to remember reading something about this type of interface on Metalink a few months ago but cannot find it anymore.

Thanks,
Curt Received on Fri Mar 24 2000 - 02:11:56 CET

Original text of this message