We have a performance issue with a query object in NAV BC14.
We isolated the code snippet with the Performance Profiler that caused this issue and we stumbled upon a SQL statement (caused by an Query.READ) which needs 7-10 seconds to run through.
The SQL statement looks like this:
The code that calls the SQL statement is the marked line (StundentabelleAbwesenheiten is the query variable):
The query object that caused the problem looks like this:
We tried to create a new key in the table "DL Lohnzeile", but that had no effect on the duration time of the SQL statement:
What else could be the problem here?
Thank you very much in advance!