|
Some facts [message #70223 is a reply to message #70096] |
Mon, 06 May 2002 21:07 |
mangesh
Messages: 28 Registered: May 2002
|
Junior Member |
|
|
Test carried on Desktop DB server.
-----------
No conditions.
SQL*Loader: 6 seconds. (8006 records loaded successfully).
PL/SQL: 8 seconds (File read consumed all the time, 8006 Bulk insert took less than a second)
-----------------------
Loader script with conditions, and some Japanese data (same added to PL/SQL loading script).
SQL*Loader 4 seconds. (for 109 records).
PL/SQL 0.5 seconds. (for 109 records).
---------------------
|
|
|