For each job that we run, we can see a call to OrderTablesByConstraints(), which always goes to the database to fetch the list of constraints.
This list doesn't change that often, and because of how integrations are setup, we see this query being executed hundreds and sometimes thousands of times daily.
Could this be cached even if for just 5min? That would drastically reduce the execution count in sites with high and/or frequent data integration jobs.
Nuno Aguiar
For each job that we run, we can see a call to OrderTablesByConstraints(), which always goes to the database to fetch the list of constraints.
This list doesn't change that often, and because of how integrations are setup, we see this query being executed hundreds and sometimes thousands of times daily.
Could this be cached even if for just 5min? That would drastically reduce the execution count in sites with high and/or frequent data integration jobs.
Nuno Aguiar