3093 Posts in 875 Topics by 654 members
|Go to End|
15 April 2012 at 1:27am
Ok I have a performance question. Consider the following
Page A has many Object B and has Many Object C
Object B Has One Page A and Has 1 Object C
Object C Has One Page A and Many Object B
When I render the page and I need to get the Object B has 1 Object C relation, does it run the relation query for each instance of Object B or does SS already know it has Object C because of the Has Many Relation with the page?
I know its not a big deal on small numbers, but I worry at how it will scale. Would it be better to cache Object B and Object C and pull the relationship data from that cache or will the extra filter operations cancel any performance gains?
15 April 2012 at 4:19am
You could maybe check out what happens by adding a ?showqueries=1 to your URL. I often use that in situations like this...
|Go to Top|