[Typo3-dev] database relations in TYPO3

[Dmitry Dulepov]

Hi!

Ries van Twisk wrote:
> The advantage of having real database relations is that in general
> retreiving large data structures is faster
> then calling the RDBM over and over again.

You do not need to call it many times with existing solution if database
supports nested SELECTs (see below).

> Also you can easely make relations in such a way that you can delete
> releated record automaticly,
> or use triggers to set a 'deleted' bit on a field. It keeps the database
> consistend.

...if database supports it. MySQL 3.23 does not. It does not support
nested queries either, so
	select * from sometable where uid in
		(select relation_field from anothertable)
is impossible too.

There are still many 3.23 installations around.

Dmitry.