I’m curious if there is best practice to do lookups using the Db context in a BPM. I currently have an external BPM that is looking up records in UD106A. Similiar to this:
var results = Db.UD106A.Where(w =>
w.Company == company
&& w.Key1 == key1
&& w.Key2 == key2
&& w.Key3 == key3
&& w.Key4 == key4
&& w.Key5 == key5)
There are a lot of records in this table and it’s hit quite often to do lookups. Come to find out the app server is holding 8GB worth of Ice.Tables.UD106A objects after doing a memory dump using the Performance and Diagnostics Tool. A quick google search recommended using the .AsNoTracking() extension? Any thoughts?
-Caleb