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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-08-21 : 13:22:20
|
| HiI receive XML files every minuteI need to use them to update and merge to tablesI read the files in the folder in sequence of arrivalUsed XML task xlt to clean them and select only require fields import them into a temp tableThat I truncate first and use a stored procedure to update and merge to the other tablesIs truncating a table every minute is bad does it affect performance is there a better way to do thatsarah |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-21 : 15:05:16
|
| I assume you are truncating and then importing the data into your temporary/staging table. If that is true, you are doing the right things; truncating the table is faster than your other options. You can see why if you take a look at the remarks section on this page: http://msdn.microsoft.com/en-us/library/ms177570.aspx |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-08-21 : 18:33:06
|
| If I am truncating the table every minute does this affect my database or the performance or overloads somethingThankssarah |
|
|
|
|
|
|
Merging to a table from XML every minute