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
My mistake !
I found out that drupal already doing this. the body and the teaser is in node_revisions table.