UUID's are the simplest general solution. With integer id's you must coordinate with a central authority (the db server) to avoid collisions.
Space is cheap.
Paul
On 3/25/16 3:54 PM, Mike Copeland wrote:
Paul,
If I were to say "that's overkill for my application's needs" you would say....?
Just wondering what I'm not understanding here. Is it that I'm thinking too small?
Mike Copeland
Paul McNett wrote:
On 3/9/16 3:17 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
I created the new incarnation of FabMate a year ago with 16-byte character keys. Works fine, but I wanted to entertain the idea of using integer keys again instead (because I love the idea of 4 bytes instead of 16)
You are concerned about using 16 bytes instead of 4? IMO you should be using 40-byte uuids for everything these days.