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

[Martin Kutschker]

S. Teuber schrieb:
> 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. 

You would either clutter up tt_content_ext or would get lots of 
additional tt_content_ext_* tables.

The former would give you no performance gain, because the table would 
have to joined with tt_content for normal content rendering.

The latter would mean an even greater perfomance loss as you would have 
to make a new SELECT for each content element.

Use flexforms if you need more fields if you're worried about the number 
of fields in tt_content.

Unfortunately flexforms are flexible but don't work well in a Typoscript 
context. And they cannot be configured by page TS. :-(

Still, they are a useful and powerful option for plugins. We should IMHO 
rather think about improving them, than about addin new tables.

Masi