• Could you give us a little more to go on? The DDL to create the table and something about the insert that's taking a lot time would be a good place to start.

    As a shot in the dark:

    What indexes do you have on the table where you're having a problem? If it is over-indexed, that will have an impact on performance.

    Do you have any triggers on the table where you're having the problem. These have a significant impact on inserts.