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)!