6

I've created a Content Type that will have >50 fields. I've noticed that each field has a corresponding table. Is Drupal joining 50 tables in order to load the page with all of the designated content?

Would a high amount (but not an unnecessary) amount of fields cause a noticeable decrease in performance?

Thanks in advance for your answers.

7

Answer really depends on your database backend. If you're using something like MySQL 5.6 or MariaDB 5.5 I would say probably not http://www.mysqlperformanceblog.com/2012/04/04/join-optimizations-in-mysql-5-6-and-mariadb-5-5/. If you're using a different database backend, it will be hard to tell without testing.

If using something like MongoDB for the field backend then it shouldn't cause any performance issues.

If you don't want to go with MongoDB or bleeding edge MySQL you can also look into using something like the Entity Cache if you find that all the fields is causing performance issues.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.