[development] merging node tables (was: Drupal 6 code freeze)

[Khalid Baheyeldin]

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.
>
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20070702/31eb70ac/attachment.htm