AnsweredAssumed Answered

Larger Tables (more fields) or Multiple Tables?

Question asked by vadev on Nov 17, 2011
Latest reply on Jun 20, 2012 by mark.richman

Hello Everyone,


I was curious as to your opinions this. Is it better to have fewer tables with many fields, or several tables with the less commonly needed data removed to a different table? It seems logical to me that reducing the size of a commonly accessed table would have optimization and performance benefits as the less-commonly needed data never needs to be loaded until specifically requested. Clearly a database with fewer tables is easier to organize, but are there any real performance / optimization gains from this approach? If so, at what point (number of fields) would you consider it worth-while to separate the tables?


Any other considerations are also much appreciated!




PS. I'm a new-to-FM from (mostly) MySQL and can't imagine going back (given the choice of course)!