I want to save xml data with the following structure in the database
<root>
<static>...</static>
<dynamic>...</dynamic>
</root>

Each subnode, static and dynamic, can contain a lot of child nodes. The static part will remain unchanged once created, but the dynamic part will change with each update. I have two solutions,
1. save everything in a single xml column, then use xml dml to update the dynamic part, but for each update, two actions are needed.
update mytable set @xml.modify('delete ...') followed by update mytable set @xml.modify('insert...')

2. store static and dynamic into two separate columns, and use normal update statement to replace dynamic column as a whole for each update

I would like to know which solution will give better performace based on your experience. Any comments are welcome.