Drupal 7 CCK fields in separate tables - why?

Mukesh Agarwal <[email protected]>
Newsgroups gmane.comp.php.drupal.devel
Message-ID <CAE55W0v6b8RWhfi+3bY2MoTKfUTwEi52FYLya=XjiEog18Td4w@mail.gmail.com>
Hi Everyone,

I'm sure I'm asking a question that people might have been asking for long.
Please bear my ignorance on following all the development threads.

I'm right now designing information architecture for one of my clients in
Drupal 7 and it turns out that there are many attributes associated to the
entities. Now that CCK fields are all stored in separate tables, my node
pages now have sql queries that have numerous joins and the performance goes
for a toss.

Does anyone know a good reason for moving from the previous schema? Single
valued cck fields are in the content type and multiple valued fields form a
new table. What was wrong with that?

-- 
Cheers,
Mukesh Agarwal
________________________________
Innoraft Solutions <http://www.innoraft.com>  || +91 8017220799
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.