• 22 minutes for 10,000 rows? You have another problem somewhere. That should be closer to 22 seconds for 10,000 rows.

    How big are the rows? Is there a BLOB involved? How many indexes on the table? Is there a trigger on the table?

    What's the batch size on the bulk insert? Is there a lot of blocking going on while this is running?


    And then again, I might be wrong ...
    David Webb