TOracleDirectPathLoader: a question about performance

windnet

Member
C++ Builder 6.0, Oracle 9i.
The sample table has 30 columns, while load 2000 rows into table, it may cost about 800 to 900 millisecond. But while just load several rows (such as 1 or 9 rows) into table, it may cost 600 to 1200 millisecond while call Finish().
Why it cost so much time to insert just several rows?
Thanks for any help!
 
There may be some initialization overhead when you first use the loader for a table. For smaller loads this overhead is more significant.

What happens if you perform a similar small load twice?
 
Back
Top