|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, January 26, 2010 7:36 AM
Points: 103,
Visits: 221
|
|
I was thinking about this some more and I would expect that the DB must deserialize each value from the varbinary storage to your UDT representation to check equality. Unless you are setting some .NET attribute (if one exists) that tells the DB that the way you serialize the values provide strict weak ordering, it can't know that e.g. 0xBBBB is a "greater" IP than 0xBBBA. If it doesn't know it has strict weak ordering I don't see how can it walk a b-tree.
I don't really have time to look into it I'm afraid, I just have enough time to wonder about it for a moment and then get back to work 
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, December 10, 2007 8:59 PM
Points: 5,
Visits: 8
|
|
In the SqlUserDefinedType attribute you can tell it to use byte ordering, which is what I do.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, January 26, 2010 7:36 AM
Points: 103,
Visits: 221
|
|
| Hey slick, I think your approach is my favorite then. Cool beans!
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 01, 2009 7:22 AM
Points: 122,
Visits: 45
|
|
yes that sounds great - has someone an example of this? regards audi
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, January 13, 2010 9:13 AM
Points: 4,
Visits: 20
|
|
One question
What happens when they move to IP6????
|
|
|
|
