-----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-----