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

Franck N

Hi,

ORDS release 19.4  is not yet made available to public knowledge.

the latest release  is Version 19.2.0.199.1647; August 1, 2019

regards,

Franck

thatJeffSmith-Oracle

end of the calendar year .. with all of the necessary caveats of course

1 - 2
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
985 views