[development] merging node tables (was: Drupal 6 code freeze)
kb at 2bits.com
Tue Jul 3 01:34:09 UTC 2007
On 7/2/07, Gerhard Killesreiter <gerhard at 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.
Here is a timely article on implementing counters from a MySQL point
Food for thought.
Drupal development, customization and consulting.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the development