On Mon, Sep 22, 2008 at 02:36:00AM -0400, Jim Starkey wrote: > Auto increment is feasible only if the database engine runs on a single > computer. Any possible distributed database requires a full round trip > between servers to implement auto-increment, making their performance > untenable in future database systems. This isn't problem in MySQL or > Drizzle, but will be in future database systems, big time. Sequences > don't necessarily have this problem since they can be preallocated in > blocks, but auto-increment semantics make this impossible.
We pre-allocate auto increment in blocks today in ndb (per thread and per sql node) and nobody really complains (they go 'huh' and are then okay with it). -- 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
