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

[Ries van Twisk]

Arne Skjaerholt wrote:

>I've run into some problems myself with this when developing. As you
>said, I found a (reasonably) painless solution with LIKE. In my opinion
>the best solution would be your option number three and removing all the
>comma-separated stuff from the next version, but options one and two
>might be good additions while the next version is being developed.
>
>Arne
>:wq
>
>_______________________________________________
>  
>
I don't understand how I can do a like to look for a relation.

For example I have this list in a record:
345,6,17,231
How would I do a like query on this one to look for number for UID 1?

Also, a query like this: LIKE ('%somedata%') cannot be optimized at the 
DB level
because the RDBM cannot do a index scan but rather have to do a 
tablescan, means has to scan ALL records!

I would love to see MM relations,
unfortunatly I don't think that's possible anymore with typo3....

I have seen however that Kasper did some speed measurements and found 
that on mysql there is
hardly no speed differences and so decided not to go for a relational DB 
setup.

Ries