Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: real time data load
Your best bet would be OCI in general (not sure if the stored proc would be
the most effecient). But using OCI and host variables and array inserts
would be very fast. Minimizes the round trips and minimizes the parsing.
ODBC supports string substitution for host variables instead of host
variables and so OCI should be much faster. Host variables are important to
minimize the reparsing (CPU load on the server). They would speed things up
signifigantly.
Jim
"Leon Rzhemovskiy" <lrzhemov_at_home.com> wrote in message
news:3A04D411.9B2B2F10_at_home.com...
> I have to load into Oracle database “real time” data. The volume is 5000
> records per second. Transaction are mostly updates and inserts. C
> application is suppose to pass data into Oracle.
>
> I plan to connect C app to Oracle using ODBC and call stored procedure
> to process data.
>
> What kind of performance improvement I would have if instead of ODBC I
> would use OCI to call stored procedure?
> Does it make sense to pass to stored procedure not a single record but
> array, so it will be less stored procedures calls, but I will need to
> process array record by record inside of pl/sql?
>
> Any other recommendation for high volume real time data processing
> would be appreciated.
>
> Thanks
> Leon
>
>
Received on Sun Nov 05 2000 - 02:32:07 CST