| Hi,
When I do this:
bpObject = new BlockProperty(); ec.insertObject(bpObject); bpObject.setValue(value); bpObject.addObjectToBothSidesOfRelationshipWithKey(bObject,"block"); bpObject.addObjectToBothSidesOfRelationshipWithKey(pObject,"property");
This will take 90 seconds to complete (will all the rest of the code)
I can see in the debugger that every time I do a AddObjectToBothSidesOfRelationshipWithkey WO will perform a select-statement, the relations have a lot of records (>2000). I have to to that a lot of time and all I need is just to make a relation between the objects. Why is WO performing a select every time and can I avoid that? If I just do : bpObject = new BlockProperty(); ec.insertObject(bpObject); bpObject.setValue(value); bObject.addToBlockProperty(bpObject); pObject.addToBlockProperty(bpObject); This will take 5 seconds to complete (will all the rest of the code)
Thanks, Frank Stock |