So I have a query that is timing out in E-10. When I bring it into toad, it runs in under .3 seconds. I have a bunch of intermediate calculated fields that I had to replace to get it to run in SQL. Do those intermediate calc filed in Epicor affect the performance? Is it better to calculate as much as you can in one calculated fields instead of making intermediates and referencing them?
I’m mot sure what the general rule would be on whether to use subqueries or not.
Here a are a few of the things that I have noticed can make a difference in overall execution time
- when primary index fields are not included in queries/subs
- where criteria are applied to your queries/subs
- how queries/subs are linked
I’m not talking about sub queries, I’m talking about a calculated field being used in another calculated field in the same query.
Calculated fields should not cause performance issues as long as they are not sub selects