Oracle interface (SQL, OCI, ...)
From: Curt Ingram <cingramb_at_bigfoot.com>
Date: Fri, 24 Mar 2000 03:13:09 GMT
[Quoted] [Quoted] Message-ID: <93BC4.191$eL2.45527_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 because reads and writes on individual records in C-Tree are very efficient whereas with Oracle they are not. The application repeatedly reads a single [Quoted] record, updates it and then reads another, etc. I would rather not rewrite 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.
Date: Fri, 24 Mar 2000 03:13:09 GMT
[Quoted] [Quoted] Message-ID: <93BC4.191$eL2.45527_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 because reads and writes on individual records in C-Tree are very efficient whereas with Oracle they are not. The application repeatedly reads a single [Quoted] record, updates it and then reads another, etc. I would rather not rewrite 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 - 04:13:09 CET