I am creating a content type in Drupal - a content management system for our business rules. This content type will ultimately contain about 40 fields. I notice that for each field I create for the content, Drupal creates a table in MySQL.
It sounds like when I go to query the content in MySQL from a remote system using, say, JDBC, will I need to create a query joining 40 or so tables?
Does that sound right? Can I be doing something wrong? I cannot believe that a query, even with adequate indexes in place, would be performant when 40 tables are joined together.