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?