Using relational database structure and effects on storage and search filtering

[eve]

Hello!

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

Let’s be nice, please 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) If you’re expecting to have a list > 100 items, I always recommend establishing the relationship in the other dire…

This post by Josh might be particularly helpful here. In general, if you have a performance-related question, it’s always worth reading through Josh’s performance-related posts (though be careful with the old ones, some info from 2016 may not still apply )