Re: UUID vs Compound Key
From: hoodwill <chase.saunders_at_gmail.com>
Date: Mon, 12 Jul 2010 17:38:36 -0700 (PDT)
Message-ID: <58581f3e-1771-45ed-a535-5c6bd795a008_at_s9g2000yqd.googlegroups.com>
Date: Mon, 12 Jul 2010 17:38:36 -0700 (PDT)
Message-ID: <58581f3e-1771-45ed-a535-5c6bd795a008_at_s9g2000yqd.googlegroups.com>
Mark, I don't know that it would introduce performance problems, per se. However, I believe that if you use GUIDs then as a consequence different records will fall on different data pages more or less at random. If many queries in fact work with individual "sites", then many additional data pages may have to be accessed based on a GUID primary key, versus the compound key, which will place data from the same company together. Hope this make sense. Received on Tue Jul 13 2010 - 02:38:36 CEST