Re: Oracle interface (SQL, OCI, etc.)
Date: 24 Mar 2000 02:06:33 GMT
Message-ID: <20000323210633.02600.00003585_at_ng-fa1.aol.com>
>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
>
It sounds like you want to use cursors [allowing row-by-row processing rather
than set processing like SQL does]. However, that would probably mean a lot of
rewriting of the code.
Dan Hekimian-Williams Received on Fri Mar 24 2000 - 03:06:33 CET