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 { jobHea…

NEVER join a tt table to a Db context. :slight_smile:

Seriously!!! Don’t do it!!! You are bringing ALL your jobhead records 100% of them into memory [image] E10 BPM Slow due to Join? ERP 10 [image]

In other words if you ever want to use the Epicor Widgets and not Custom Code and you are a large company and you need to join on ttPart you are screwed… Can we just say Epicor doesn’t support large companies, only small mom an pop shops :slight_smile: maybe they will find a way to fix the widgets a…

You can make them work with the widgets. Make a variable for every item in that you need to join to your tt. Use the setter to assign your variable to the tt value. In the query builder add the variables as a criteria to the table. It’s a pain, but better than returning every part record.

Thanks @hkeric.wci and @josegomez, we are really new to C# Epicor development and Linq. As I think most developers would agree - we don’t like magic(just do this and it is fast, don’t do this it’s slow) we really want to understand why so we can reason about solutions and troubleshoot problems. I t…

Hi @embedded in the link I reference above there is more explanation but it is not necessarily an Epicor issue. The issue is that a ttTable in a BPM is a POCO (Plain Old Class Object) while the Db.JobHead is a context table. A context table is understood by SQL while a POCO is not, so when you sa…

Help with slow Linq query

Epicor ERP 10

josecgomez (Jose C Gomez) November 3, 2020, 2:06am 3

Seriously!!! Don’t do it!!! You are bringing ALL your jobhead records 100% of them into memory

Topic		Replies	Views
E10.1 BPMs are Slow Epicor ERP 10	12	1824	November 7, 2016
E10 BPM Slow due to Join? Epicor ERP 10	44	8089	April 5, 2022
Apparently, LINQ method syntax for joins is broken in BPMs...? Kinetic ERP epicor , bpm , kinetic	62	5399	November 20, 2023
BPM SPEED Helpful Hint - be careful how you "Join" Epicor ERP 10 bpm	18	4772	September 13, 2021
SQL join statement issues Epicor ERP 10 e10 , sql , baq , ssms	6	2283	April 14, 2022

Help with slow Linq query

Related topics