question

sergiord2017 avatar image
sergiord2017 asked

massive load

Hi , I have to load one text file of 6 million records once per month into a fact table has 200 Million records and a few indexes to make it usable. With a wizard loader , the load delays 24 hours...so i am thinking on changing the load into a bulk insert into a staging table and then make a insert to the fact table. Will it be faster to load into a intermediate table and then make a insert into the fact table? I have doubts with disabling the indexes of the fact table before loading with the insert and rebuild after the load. I am not sure if rebuild an index of a fact table with 200 million of records... Thanks in advance.
bulk-insert
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Do you have a dev/test environment? This questions could be answered by simply running the tests and measuring them. If you don't have a dev/test environment... you have a good argument to ask for it! It's really hard to give a certain advice because there are a lot of variables here and need to consider a lot of things (ex. storage underneath, hardware, SQL Server version/edition, instance/db settings, data type, etc).
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.