I am new to database,I am using SSMS 2008 R2 to import 2GB of data from a .csv file.
It is taking around 115mins to import.
Can anybody let me know any better way to perform this import.
-
You should show the definition of the table(s) involved, how the data is clustered, how many indexes it has, ... and some indication of the hardware on which the database it's running, to help assess whether 115 mins is considered normal or not.– joanoloCommented May 19, 2017 at 6:35
-
1Not only that.... what code are you using to import it? As far as we can tell you're just typing it in manually.– Nick.McCommented May 19, 2017 at 8:32
Add a comment
|
1 Answer
You need to use bcp.exe or SSIS. Read Import and Export Bulk Data by Using the bcp Utility (SQL Server) and The Data Loading Performance Guide. Also, read How to Analyze SQL Server Performance to be able to tell why something is slow.
After you've read those, come back with a more actionable question, including structure of table, csv structure, repeatability of the job, access issues etc.
answered May 19, 2017 at 6:45
