Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Table Design - Use Xml Column or EAV Model? Expand / Collapse
Author
Message
Posted Tuesday, November 04, 2008 9:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, February 02, 2013 8:21 AM
Points: 283, Visits: 268
So I am hitting some resistance on a design. Basically, the DBAs don't like using the Xml datatype in the database tables. Instead, I've been told to create a table that stores Attribute Value pairs. Basically, we're storing either scaler or complex values into the Xml column, however, they all have the same Xml Schema. Now, I need to split the data from the Xml coming in and put it into multiple Rows in an EAV table. Don't get me wrong, I am a fan of EAV when it's needed, however, I don't think it's needed in this case.

My question is, what really is the performance impact of the Xml datatype? I mean ideally using the [TEXT_FILEGROUP] of the table I am able to store the Xml data into a seperate FILEGROUP and therefore even a seperate physical file on disk. I understand that space-wise it's probably a little larger, but if this one Xml column is never Indexed or used in any WHERE clauses, what is the performance impact of it?



Post #596681
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse