Vertical Partitioning for nodes table

Events happening in the community are now at Drupal community events on www.drupal.org.
ghayoumi's picture

We have a website and we want to migrate to drupal. I have never build a website with drupal before. we might have 200,000-300,000 new pages in {nodes}.body each month. for the current website we had to denormalize database and call a second query to select the longText field and we had a significant performance gain. Can we somehow denormalize the nodes table and separate the body field. what do u think ?
you can also check this address to see an example of vertical partitioning performance gain.
http://dev.mysql.com/tech-resources/articles/performance-partitioning.html (See: A Quick Side Note on Vertical Partitioning).

is it not better for the drupal core to split the body field of nodes table ?

Thanks for your time.

Comments

Correction

ghayoumi's picture

My mistake !
I found out that drupal already doing this. the body and the teaser is in node_revisions table.

MySQL

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: