Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2008-02-20 : 07:13:45
|
| Hi,I created a package to load a fact table which loads more than 7 million records.When loading the table it took nearly 15 minutes.Then indexes were created for the table at the DB level after which the time to load same number of records has increased.How to resolve this time delay? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-20 : 08:48:50
|
| Drop the indexLoad dataPut index backMadhivananFailing to plan is Planning to fail |
 |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-02-20 : 16:18:05
|
| Are you using fast load that will be fast |
|
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2008-02-21 : 02:23:03
|
| I am using fast load only. |
|
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-21 : 16:06:52
|
| There are a lot of factors that will slow down your import. 7m should take 3-4 mins on a modern server at MOST. What else are you doing in the DataFlow? How is your destination configured? Will this package be run on the SAME server as the DB? Is the DB a 2005 DB? Is there data already in the table? You are creating the indexes after you load the table? |
|
|
|
|
|
|
loading data to a table