Was using 3.4.6.1 for a loader using DirectPath, but after compiling under 4.0.1 it is taking about twice as long. Ran a test with Demo app under 3.4.6 and 4, with the following results:
3.4.6
31008 Lines
Single Inserts: 23.223 sec
Array Inserts: 1.683 sec
Direct Path Loading: 0.801 sec
4.0.1
31008 Lines
Single Inserts: 22.363 sec
Array Inserts: 1.543 sec
Direct Path Loading: 1.903 sec
Database is same in both cases (9.2.03) And test was run several times to ensure it was not a network of database load issue.
I am loading between 50k and 200k records and the difference is quite noticable. Oracle 8.1.7 was faster then 9i, so this is another hit to the performance. Is this typical? Is it being investigated?
3.4.6
31008 Lines
Single Inserts: 23.223 sec
Array Inserts: 1.683 sec
Direct Path Loading: 0.801 sec
4.0.1
31008 Lines
Single Inserts: 22.363 sec
Array Inserts: 1.543 sec
Direct Path Loading: 1.903 sec
Database is same in both cases (9.2.03) And test was run several times to ensure it was not a network of database load issue.
I am loading between 50k and 200k records and the difference is quite noticable. Oracle 8.1.7 was faster then 9i, so this is another hit to the performance. Is this typical? Is it being investigated?
