I'm having Data Window performance issues on users machines.
Where a data window retrieves a large amount of data, it will retrieve the data from the DB fast but will then freeze when the user tries to click anywhere inside the window, whether that be on a field or trying to scroll.
It will hang for a while and the application will show not responding. The length of the hang time correlates to the amount of data in the data window.
Once it comes out of the hung state the data window then operates as normal with now no hanging or lag time.
When the user then exits the data window the application hangs once more for around the same amount of time.
Most of our Data Windows require from and to date parameters for the users to narrow down their results, so they are able to workaround the issue by narrowing the date range.
I'm assuming it is memory related as the issue does not occur on my dev machine which has 16GB RAM, whereas he users machines only have 8GB.
Has anyone experienced the same issue? Does anyone have any ideas on how I could fix this, without adding memory to the users machines.
I am on PB 2017 connecting to SQL Server 2012 using ODBC.