InstantForum.NET v4.1.4CapableObjects Forumshttp://www.capableobjects.com/apps/InstantForum414/forums@capableobjects.comWed, 08 Feb 2012 22:45:44 GMT20http://www.capableobjects.com/apps/InstantForum414/Topic4951-4-1.aspxIf you drill down into that function you will probably find that it performs fetches. the GetEntry-operation retrieves a preparsed ocl-expression from a parse-tree cache and is expected to be fast. It is hard to tell if you can make it faster without knowing the following:<br><br>What is the expression?<br>Is any data prefetched?<br><br>Wed, 03 Mar 2010 11:34:44 GMTJonas Hogstromhttp://www.capableobjects.com/apps/InstantForum414/Topic4951-4-1.aspxI was doing a performance trace to see where my loop was lagging. Of course, I found that the majority of the lag was from the non-Eco part of my loop, but I did notice an oddity while looking at the Eco timeline.</P><P>I have a situation where I am looking up a record by search criteria. The search table is expected to be large, very large even, and so I am doing it in a 2 part process. 1) OclPs.Execute() and if not found there, 2) Ocl.Evaluate() against allLoadedObjects - part 2 is because the one I am looking for might be a new one in memory.</P><P>I know I only had a small number of objects loaded and so I was surprised to see that the Execute (754ms) was better than twice as fast as the Evaluate (1692ms) so I drilled down into the Evaluate() to see what took so long. It spent nearly all of it's time in AcceptVisitor (1529ms) and only a very small amount of time in GetEntry (158ms). SEE ATTACHED PIC</P><P>My questions are: 1) What is it doing in that function that takes so long (relatively)? and 2) Can I avoid it or make it faster?Tue, 02 Mar 2010 22:15:15 GMTRickWeyrauch