On 2016-03-25 18:23, 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.
Craig Boyd's VFPEncryption allows for the 40-byte one, but I preferred the 16-byte instead. A colleague had said however that those large keys don't do well in the SQL Server index world (it's late so I can't recall the specifics but something about balancing I thought).
So why do you say 40-byte is the way to go? What's the advantage? Certainly the index sizes are larger (and that's not good).