we have the following
objectA is referenced in objectB
objectB has a IList<TypeA>
We want to remove A from B.
Therefore we used:
If(B.IListOfTypeA != null)
Which seems to be quite simple.
Now we have the following problem: speed.
We have 4500 objects in the list.
If we try to look wether object B has a list ( If(B.IListOfTypeA != null) ) this command needs over a second.
Digging deeper and using the OpenAccess.Profiler in the profiler is shown that :
Navigation ....TypeB(Key=...).IListOfA takes up the complete time (2 selects with e.g. 993 and 653 ms are shown).
Is there any way to speed it up?