in reply to large file and processing efficiency

You could also move more of the processing to the rdbms by dropping the entire datafile into a temporary table and then issue something like:
insert into realtable select temptable.* from temptable, realtable leftouter join temptable.ID on realtable.ID

Replies are listed 'Best First'.
Re^2: large file and processing efficiency
by chiragshukla (Initiate) on Dec 07, 2005 at 20:03 UTC
    Yes, thats a good idea too. Thanks, beachbum.

    Regards
    Chirag.