On Tue, Aug 12, 2008 at 10:43:16AM -0700, Robert Hodges wrote: > Some of the previous data type conversations reminded me of a question > that's been on my mind for a while. What do you think of dropping > auto-increment keys and replacing them completely with UUIDs? > > Auto-incrementing is one of the banes of horizontal scaling so it seems > reasonable to substitute something that works across partitions and data > copies. Or at least to give application developers an opportunity to > suppress it.
Depends on how you use them... we do horizontal scaling in NDB and we deal with auto inc fine (we prefetch batches of them). So if you were more cloud like, there is no reason why you couldn't have something like this plugged into the sql server. But having UUIDs as an alternative is win :) -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
