Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PRO*C Performance of bulk insert

user11986827Apr 19 2018 — edited Apr 19 2018

I'm looking for advice on how to get the best performance out of large inserts in PRO*C.  Any information is appreciated.

We have a C++ application that stores data in memory via arrays. We use Pro*C to take that C++ array data and perform a bulk insert using the following method:

EXEC SQL INSERT INTO emp (empno, ename, deptno)

    VALUES (:emp_number, :emp_name, :dept_number);

Is this the fastest possible way to insert data into Oracle with Pro*C?

Any suggestions on how to do large inserts in PRO*C faster?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 17 2018
Added on Apr 19 2018
2 comments
984 views