On Sun, Mar 27, 2016 at 10:45 PM, < [email protected]> wrote:
> On 2016-03-25 19:56, Ted Roche wrote: > >> Satellite offices. With UUIDs, each app can create *unique* IDs that >> don't have to be changed when you merge IDs from multiple sources. >> Solves problems with roaming salesman, remote offices, off-line use, >> etc. >> > > > This is why I went with the app-generated character keys this time around > instead of the integer keys I'd used since 13+ years ago. Still, the > 16-byte keys should suffice for this. > > ------------------------ For me it was moving business that was prepped in test and easily moving it to production. The keys are no longer an issue. The issue with indexes is the free space available in an index page before it has to split into two pages for the same data. This is only in a primary key because it can always be a problem in the secondary one. The GUID generated may fit into any one of different btree index pages, but a int will only be placed at the last page. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYKjP2BGGjDUuux0AXfiRneg0NvPiaan3xJaED_wqMra=a...@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.
