Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle interface (SQL, OCI, etc.)

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@newsread2.prod.itd.earthlink.net>


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 Thu Mar 23 2000 - 19:11:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US