Re: sqlldr very very slow

Noel wrote:

> When someone hits enter button to run program which is going to load a
> 6M records with autocommit feature, then he's waiting a three hour and
> nothing will happens, then seeks help via internet to solve problem,
> then i realized that is sort of test database,...

I hope you are correct that it was a test database. But I saw nothing that indicate it in the post thus my reaction. Like I say ... I hope I am wrong but I certainly wouldn't want anyone to think disabling triggers has no consequence.

That said consider the implications of your advice in a test database.

[Quoted] Suppose the trigger is used to load another table that is essential for the proper functioning, and thus the testing, of the application. What then? I hope you see the source of my concern.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)