real time data load

From: Leon Rzhemovskiy <lrzhemov_at_home.com>
Date: Sun, 05 Nov 2000 03:28:37 GMT
Message-ID: <3A04D411.9B2B2F10@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 Sat Nov 04 2000 - 21:28:37 CST