[development] Why do we avoid auto-incrementing db columns?

[Gerhard Killesreiter]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Earnest Berry III schrieb:
> Hi Sammy,
> 
> There's only on thing I disagree on; the performance hit of the mutex lock.
> If you do not have a relatively large number of insertions, than this is not
> a large performance hit; however, if you do, this does become a performance
> hit. I admit, I'm on the extreme end of the spectrum as I was inserting some
> 20 million nodes (which, expanded means 20 million nodes, 20 million
> node_revisions, and 7-14 million other insertions in diff. tables for the
> application). 
> 
> After implementing random-id generation with out locking the table ever at
> all, the performance increase was very noticeable, on the order to 70-100%
> more throughput of node creation.

http://drupal.org/node/55516

You'll find this interesting.

Cheers,
	Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGL4vHfg6TFvELooQRAjpKAKCBPK+yW2CfpFGdTxmYyrFJdoL8egCfenj8
vR8BKlJxyTdTyb0Aip1T1AU=
=HooF
-----END PGP SIGNATURE-----