One-to-many-to-many-to-many performance

Need help Database
9

  1. Let’s be nice, please

  2. If A has a list of B, whenever you load A, you load all the ids of Bs in that list. We may change this eventually but no short-term plans to do this. We don’t actually load the rest of the data for the Bs unless you actually reference a property on the Bs. (I think! If you can build a simple test page that demonstrates otherwise, submit it as a bug)

  3. If you’re expecting to have a list > 100 items, I always recommend establishing the relationship in the other direction: have B have a single A, and then do a search for all B’s with that A. For lists < 100, it might be a little faster to do it via a list.

16 Likes