Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insertion Expand / Collapse
Author
Message
Posted Thursday, August 27, 2009 12:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 22, 2014 4:35 AM
Points: 172, Visits: 258
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
Post #778063
Posted Thursday, August 27, 2009 2:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
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?



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #778099
Posted Thursday, August 27, 2009 6:46 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:07 AM
Points: 828, Visits: 1,702
SSIS is very good at handling insertions of large amounts of data. You should definitely consider it.
Post #778229
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse