By Laurentvw on

I'm trying to make drupal more efficient to my needs (gotta have millions of nodes). I cannot understand why the node's comment count, for instance, is being stored in a separate database table. Wouldn't it be better to just add a new attribute to the node table that would hold that number? This avoids an unnecessary JOIN when pulling the data out of the DB.
Please correct me if I'm wrong, but in my case, it seems more convenient to use my tweak. Right?

There are some other stuff, similar to the comment count, that I'd like to add on the "node" table.

Now, for the comment count to be updated in the node table as well, I guess I'll have to edit the comment module. I will look into it, but any guidance would be appreciated (if you feel like helping out).

That's all I had to say.. looking forward to your opinion.

⋅ Categories: Drupal 6.x

Comments

kenorb’s picture

kenorb commented

This is how Drupal db schema has been designed.
You should have cache enabled to make to more efficient.
http://www.drupal.org/project/boost
http://drupal.org/project/cacherouter