DD BPM Custom Code - Synchronous vs. Asynchronous

[Banderson (Brandon Anderson)]

Lots of posts about that. Grab your variables that you need first, then use that to filter.

Help with slow Linq query

We have the following Linq query in a method directive and user’s started reporting slow performance and we found this query takes 15 seconds. Any suggestions/pointers as to why it’s so slow? var rows2 = (from jobHead in ttJobHead join jobHeadDb in Db.JobHead on new { jobHead.JobNum } equals new { jobHeadDb.JobNum } join jobProd in Db.JobProd on new {jobHead.JobNum } equals new {jobProd.JobNum} join partRow in D…