Hello,

I want to create 310 fields in a node in drupal 7. But as per drupal it will create 620 tables for those field. So please help me that how I can use 310 field in a single content type with minimum tables with good performance.

Please guide me that what I can do for it?

Comments

arulraj’s picture

With help of Field SQL norevisions we can avoid revision tables.

Better try to split fields to different node so its helps site performance.

ykarthikvarma’s picture

My advice is better you go ahead with multiple content types having node references or through complete custom way where a custom form would handle your data through custom created tables.

Note: Both of them have their pros and cons like No. of tables, DB load, Performance etc ...