10.1.400.15/SQL2014 Hello all, I have just recently been tasked with going through code on BPMs to try and figure out why certain ones are taking so long. I had originally run diagnostics on some server logs and found 2 that are taking anywhere from 20-80 seconds to run. The code was originally wr…

At a glance, the first thing that screams at me is the continue statements. They are a code smell. If you are doing an if and continue that means you just pulled back all that data from the db into the app server to throw it away when you don’t need it. I’d probably look at adding the condition to …

wasn’t there some hubbub about JOIING to a TT table and HOW it’s about the same as global thermal nuclear war??? does this apply here?

That was in a BPM Query. In Custom CODE it doesn’t have the same issue. At least that was the answer I got when I asked the same question.

@knash that same issue does apply to custom code. You should NEVER EVER NEVER join to a ttTable. Weren’t you at our talk? Did ya fall asleep? LoL In this case though the joins are not to the ttTable they are using a primitive within the ttRecord to as a whereClause and that is ok.

That Joining bug on tt is only if you do the joins on the tt itself. If you do var x = ttTable; and use it on the bottom to Join, you will be fine, but dont throw in your joins in the beginning. He is not doing that he should be okay foreach(var tt in (from ttrow in ttShipTo select ttrow)) But p…

I was not able to attend. Is there a recording or presentation summary. Thank you.

not to be Robin… What about a TT to TT table? still bad. I understand that you are creating an on Demand View which adds overhead.

TT to TT is fine they are small in memory POCOS have a blast!

E10 BPM Slow due to Join?

Epicor ERP 10

josecgomez (Jose C Gomez) June 8, 2018, 3:44pm 7

Notify Engineer for the First Job of a New Part

BPM - Trying to map customer comments to Sales order comments field. But it is not working

Blocking transactions for parts without STD cost

Sales Kit

Help with slow Linq query

Topic		Replies	Views
BPM SPEED Helpful Hint - be careful how you "Join" Epicor ERP 10 bpm	18	4732	September 13, 2021
E10.1 BPMs are Slow Epicor ERP 10	12	1767	November 7, 2016
Help with slow Linq query Epicor ERP 10 e10	6	2099	November 4, 2020
Bpm likely causing performance issues on intercompany Customer Shipment Entry Epicor ERP 10	14	1557	July 24, 2018
Joining "TT" records to regular DB records in BPMs Experts' Corner bpm	21	9349	April 5, 2022

E10 BPM Slow due to Join?

Related topics