[TYPO3-dev] table joins and TCA

[Jochen Rieger]

Hi Stig,

> 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.

Regards,
Jochen

-- 
:: innovative it-strategies ::
::                          ::
:: www.connecta.ag          ::