On Fri, Aug 24, 2012 at 4:18 AM, Paul Hill <[email protected]> wrote: > Hi All, > > Guids are nice but can add a significant size overhead to your database. > > In my SQL database here I have 86 tables each with a primary key and > 547 foreign keys. > Currently I'm using 4 byte ints. Guids are 16 bytes, > > Given a table with a million rows the Guid version will be 11Mb > larger, and that's just for 1 key. > > However, I do use Guids for replicating tables between different servers. > For example, my Customer table can be shared between sites. Using a > Guid I can easily identify the same customer at different sites. ---------------------------
guids are not that bad compared to say scanned medical images. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ 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/CAJidMYLPLuiLM6sbLfEt=1-du+2ql6iweyjzegdhlff2hrh...@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.
