We generate Gen 8.6 online Windows/C/SQL Server applications to run in batch.
It has been noticed that they seem to have an upper limit of memory and they several hours to finish.
Is it possible to increase the memory usage to try to improve the performance?
Therefore support suggested:
a. Look at the performance of the application database queries in SQL Server e.g. using "SQL Server Profiler" under the SQL Server Management Studio. SQL Server Profiler
b. If have significant READ EACH statements coded check if the "Multiple Fetch" option is being used for those. NOTE: By default "Do Not Generate a Multiple Row Fetch" is set on a READ EACH statement: READ EACH Properties Dialog - General
Enabling Multiple Row Fetch was tested but again it had no significant performance benefit.
It was agreed to use an SQL analyzer tool to check the database queries that are executed in the batch, which will be done at some future date.