[web2py] list:reference vs standard many-to-many relationship

Thu, 08 Dec 2011 15:46:13 -0800

Hi

are there any studies about performances on relational dbs of list:reference fields?
On the doc i read
" On relational databases they all mapped into text fields which contain the list of items separated by||"
|||and after i read:
" For|list:<type>|fields the|contains(value)|operator maps into a non trivial query that checks for lists containing the|value|."
||
what is the best way to define a many-to-many relationship in term of performances?
||

--
Vincenzo Ampolo
http://vincenzo-ampolo.net
http://goshawknest.wordpress.com

Reply via email to