[drupal-devel] forum.module dependent on comment.module
Steven Wittens
steven at acko.net
Sat Mar 5 18:14:54 UTC 2005
>What it really means is that there will be more nodes. On drupal.org the
>number of entries into the node table will about double. As long as nobody
>cares enough to provide hard test data to show Dries and us others that
>there is a negligible impact on performance this discussion is just hot
>air.
>
>Doing 50 node loads on a single page load can be fun. In contrast, the
>comments get pulled out in one single query.
>
>
There are actually many more comments than nodes on drupal.org: 30172
comments, 17281 nodes. Furthermore there are 23247 issue followups which
I believe are not in the comments table.
Comments have a simplicity to them that makes it attractive to treat
them separately. Should node access apply to comments? Should you be
able to nodeapi a comment? Should comments be able to go into the book
outline?
Plus, you'll essentially be performing two distinct kinds of queries on
that table: 1) Fetch a node, 2) Fetch a node's associated 'comments'
(also nodes). Most queries would have a type = "comment" or
type!="comment" check on them anyway (or "comment = true/false" if you
want any node as a comment), plus a bunch of other fields and code that
would be checked depending on that value. You'd be throwing together two
distinct things into one big table, which is rarely a good idea.
All of this sounds like a lot of work with no really good benefits in
the long-run.
Steven Wittens
More information about the drupal-devel
mailing list