On 7/2/07, Gerhard Killesreiter <gerhard@killesreiter.de> wrote:
Dries Buytaert schrieb:
6. I'd like to see us merge the node, node_comment_statistics and node_counter tables. (Important performance improvement that is likely to break APIs.)
This is only a performance improvement if you don't run MyISAM. If you run MyISAM this will totally push a busy DB server over the edge as it will cause table locks on the node table for every comment added (or even every node viewed if you use Drupal's view counter).
Doing this merge (and thus also "won't fix" this issue: http://drupal.org/node/109037) essentially means "don't run a high load Drupal site on MyISAM".
Now, this isn't neccessarily a bad message, but I want to make sure that people know about this message _before_ this is rolled into D6.
Cheers, Gerhard
Here is a timely article on implementing counters from a MySQL point of view. Food for thought. http://www.mysqlperformanceblog.com/2007/07/01/implementing-efficient-counte... -- 2bits.com http://2bits.com Drupal development, customization and consulting.