On 18 October 2012 15:45, MB Software Solutions, LLC <[email protected]> wrote: > On 10/18/2012 2:54 AM, Paul Hill wrote: >> >> Having said that - I don't use PKs. My databases tend to be highly >> relational and the overhead of 128bit guids is substantial. > > Thanks for that, Paul. As for the 128-bit part, is it really that much?
Well an Int is 4 bytes and a Guid is 16 (128 bits). If you have a million records that's : (1000000*4)-(1000000*16) 12000000 bytes = ~12Mb difference. Now, in each of my tables I have 4 foreign keys: CreatedBy UpdatedBy CreatedTerminal UpdatedTerminal = 4 x 12000000 So we're talking about an extra 60Mb. And that's before we start to add proper relationships! Yeah, space is cheap. Some of my customers are running SQL Express.. -- Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CADwx0+K5LWqUaotjHVbDDHccC3-agW5AoZ7=qystwakhxa3...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
