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-counters-with-mysql/

--
2bits.com
http://2bits.com
Drupal development, customization and consulting.