[TYPO3-dev] table joins and TCA

[Stig N. Færch]

>> in worst case add 30 fields to the table, should I expect a big
>> perfomance
>> hit?
>
> I don't think that this will be a performance hit. As far as I know even
> JOINs need more performance than simple SELECTs (correct me please, if
> this doesn't count for tables with huge amounts of fields).
>
>> Of course if I do this, many many fields will be empty fields.
>
> This would be just a little "dirty". But would be solution.
>
> But why not just setting up the tables as you normally would do in a
> (quite) normalized DB? Finally you can write your JOINs manually and
> execute the queries via
>
> $GLOBALS['TYPO3_DB']->sql(TYPO3_db, $query);
>
> So did I in an extension that uses 5 tables where some of them had one or
> more foreign IDs.

But if I normalize the DB design of the extensions, then it will not be very
compatible with the TCA, right?

/Stig