Posted 8 September 2017, 1:13 pm EST
We have re-written a VB6/COM application using VB.Net and everything (for the most part) is working well.
However now that I am looking at resource usage I find that the .Net version of Spread uses about double the memory of the COM version. (Unicode version in both cases)
We already had an open request to allow the use of larger resultsets (the data is loaded from a database and never edited by the user.) because the COM version capped out at about 2.5 million rows.
Unless I can reduce the memory requirement the new .Net version will cap out at about half that ... and we are sure to start getting more complaints.
Can someone provide guidelines on what we can do to minimize memory use in Spread. (Cell Types, ReadOnly, Locked, etc.)
Although the user can not directly edit the data we do provide functions to add an additional row to display totals, and we allow them to Sort, Filter, Group etc. - just no UI editing.