I've got a datawindow that serves as a source data view/edit. Meaning it has over 200 columns and it needs them all before anyone ask.
The database is one table with 18k rows. This is tiny .
Data is retrieving longer than I expect and then when we close the window, do all the garbage collection recommended the system just freezes.
Got to task manager and you can see Appeon just slowly reducing its memory usage and then after about 30 seconds it finally unfreezes.
This is frustrating is your trying to use the tool.
We sometimes have 200k - 300k rows customers want to retrieve and then filter for analysis. So we had to set the StoragePageSize to Large and rows to disk is true.
I've never understood is you need both of those of does the PageSize do that for you thru virtual memory
Also, these machines are servers and have tons of memory and space and all ssd.
As always any help sincerely apprceiated.