l****u 发帖数: 84 | 1 【 以下文字转载自 Database 讨论区 】
发信人: lalahu (lalahu), 信区: Database
标 题: Import 50GB data from multiple .txt file into MS SQL database
发信站: BBS 未名空间站 (Wed Jul 15 10:05:29 2009, 美东)
I am going to import very large stock market data from multiple .txt files (
over 3000 files) into sql database. I was wondering which is the most
efficient way to do that?
I used bulk insert and it takes me forever time (estimated 7 days) | D*******a 发帖数: 3688 | 2 have you tried bcp?
(
【在 l****u 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 【 以下文字转载自 Database 讨论区 】 : 发信人: lalahu (lalahu), 信区: Database : 标 题: Import 50GB data from multiple .txt file into MS SQL database : 发信站: BBS 未名空间站 (Wed Jul 15 10:05:29 2009, 美东) : I am going to import very large stock market data from multiple .txt files ( : over 3000 files) into sql database. I was wondering which is the most : efficient way to do that? : I used bulk insert and it takes me forever time (estimated 7 days)
|
|