Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle interface (SQL, OCI, ...)
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 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 - 00:00:00 CST