Performance issues with INNODB vs MyISAM
Not sure where is the most appropriate post for this, let me know if anybody has suggestion.
I am having performance issues with INNODB. My major issue is that with INNODB I am getting approximately 20 times slower performance than with MyISAM. For the purpose of testing I have used Drupal 7 with devel module installed. Further more I used 2 bare bone servers with default installations so I can do parallel comparisons.
Read moreVertical Partitioning for nodes table
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.