August 27, 2009 at 12:20 am
Hi,
I need to insert large amount of data into a table lets say some lakhs.
Can anyone please tell me what are the constraints i need to take care of while inserting a large amount of data?
Regards
Deepti
August 27, 2009 at 2:15 am
It depends...
You should work with chunks of data (e.g. 100,000 rows in one chunk).
Would it be okay if your tables are locked while insertion? It defines the possible count of rows to be inserted in one chunk.
Depending on your data source you probably should use BCP or SSIS.
It depends on your hardware.
Could you give more specific information, please?
August 27, 2009 at 6:46 am
SSIS is very good at handling insertions of large amounts of data. You should definitely consider it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply