xml: text or ntext

• Kevin Terry

  SSC Eights!

  Points: 806

  More actions

  July 15, 2003 at 1:06 pm

  #357937

  I am storing xml in a table, which is used later to reload an app. I figure fastest loading and retrieving would be to just store full xml text into a text or ntext column. So two questions, and pros or cons with text vs. ntext? Also, would it be better to parse out the xml for some reason, and store in database in a broken out 'relational' way, then rebuild xml later? Doesn't seem like it would be, but not sure if I'm missing something

  Thanks!