[Typo3-dev] RFC: TYPO3, Kickstarter and M-M database relations

[S. Teuber]

Hi Peter,

just for feedback: I agree with you in all points in this matter (kinda 
"global +1" ;-).

IMO the database structure needs even more improvements, for example 
keeping all those extension-added fields out of tt_content and putting them 
in an extra table (tt_content_ext), because tt_content gets kinda HUGE and 
difficult to survey if you have a large site which uses many extensions. 
Plus, you get all the overhead from the additional fields even on (most of 
the times the majority of) pages that don't use any extension, which 
affects performance. Of course, not only the database, but TCEForms as well 
needed to be adapted to handle the more complex table structures, so this 
is a long time task for version 7 or 8 at best... 

Frankly, I missed the ability to edit related tables in *one* TCEForm in 
quite a few projects, always ending up by making the database design worse 
to fit TYPO3's needs. I'm not alone with this need; we had some threads 
about this in Typo3-dev recently, as you might remember, i.e. the "'virtual 
tables' with tca?"-thread in May/June.

Sven