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