Home » RDBMS Server » Server Utilities » Bulk Inserts (using FORALL) Vs Sqlloader
Bulk Inserts (using FORALL) Vs Sqlloader [message #70096] Fri, 12 April 2002 01:48 Go to next message
M Kalekar
Messages: 1
Registered: April 2002
Junior Member
Hi,

Would like to get some statistics on Bulk Inserts (using FORALL stmt) versus insert done using Sqlloader. How much is the performance difference?

Report message to a moderator

Some facts [message #70223 is a reply to message #70096] Mon, 06 May 2002 21:07 Go to previous message
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).
---------------------

Report message to a moderator

Previous Topic: Re: calling sqlldr from a stored procedure
Next Topic: Re: Urgent!!! SQL * LOADER ERROR-524
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 14:38:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.