[development] Is it possible to have separate table for different content types in D7

Craig Forbes cpforbes at starlake.org
Fri Feb 11 17:14:28 UTC 2011


On Fri, Feb 11, 2011 at 11:00 AM, Deva <devendra.in at gmail.com> wrote:
> In my case i am going to have lots of content types with lots of cck fields.
> D7 creates new table for each cck field. So while reading a node from
> database. It is going to do a join. I dont think that is good thing.

Why is a join not a good thing?  Unless you have hundreds of thousands
of nodes the cost of a join is probably trivial.

> That is why i was checking if it is possible to have different table for
> each content type.

If you really hate using joins you could create a view in the database
for each content type -- of course drupal won't use the view but
_your_ code could.

 -Craig


More information about the development mailing list