Operation taking too long

Question

I'm trying to import a large dataset in my sql db and the operation is taking very long to complete. Is this common can we make anything and make it to complete faster.

Answer 1

Hey you can sconsider the below recomends.

Try breaking down the import into smaller batches to reducelog time tools like bcp (bulk copy) or the BULK INSERT statement for efficient bulk data loading. Temporarily disable non-clustered indexes and constraints during the import process and rebuild them afterward.

also try using parallel processing if the import tool or method supports it.

If this helps kindly accept the answer.