On Sun, Mar 27, 2016 at 10:45 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> 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.