Still working on optimizing updates. Could someone provide high-level answers to the following?
1. When you do a select that includes a reference field, how does it fetch, say, the name column, when only the id column is in the table you are doing a select on? 2. For many-to-many relationships, how does list:reference compare in performance and convenience with using linking tables and joins? 3. My list:reference fields hold a series of integer values but they do so in a column of type 'text' . They are strings of integers separated with '|'. If I were going to use SQL, rather than DAL methods to update a list:reference field of this kind, would inserting a string like this - '|100|300|450|' - work the same as a field updated by the DAL with a list? Or is the DAL doing something else behind the scenes when you update the field that would be excluded from a simple SQL update. Grateful for any input. Thanks. --
