CODEWITHSUNDEEP
c#sqlasp.netxml
themightymanuel
themightymanuel

Reputation: 135

SQLXML Bulk Load or manual iteration?

I am looking to insert a 20-25MB xml file into a database on a daily basis. The issue is that each entry needs an extra column added with a calculated value. So what I am wondering is if the most efficient way to do this would be using the SQLXML Bulk Load tools after editing the xml file, running through the xml file and add the new column then loading each item, or using the Bulk Load followed by going through the database adding the new column values.

Upvotes: 0

Views: 109

Answers (1)

Twelfth
Twelfth

Reputation: 7180

Comments = answer

There is no need to store this value seperate. Since it's a calculated value with the data you need to calculate it on each record, you can calculate this on the fly instead of storing it as it's own unique value. A mix of where and/or having clauses will allow for filtering (searching) of results based on that calculated value.

Upvotes: 1

Related Questions