Just curious what the Guru's (and above) thoughts are on normalization whereby you separate TEXT fields from a table. I was brought up on where a field was an indeterminate length then you should separate it but is that the case with MySQL? Is it true within InnoDB and/or MyISAM?
Am I just wasting my time separating the data and joining tables?
Or would I be better off just putting those fields in the main table even where some of those fields maybe blank?