Data on demand on property change
I have the following case: One data connection with several tables. I add on table to dxp first and then add rows from other tables. Data is fetched on demand for each new table based on property. For example we have 10 nodes but on property value only 3 nodes will fetch data, other will return 0 rows. When property is changed, next 2 nodes will return data while others will return 0 rows (including from those first 3 nodes).
Row count of the rows fetched is small (few thousands) while table has lots of columns (several hundreds). What we noticed is that on each property change RAM is consumed. For example on first load Spotfire consumes 1 GB addtional RAM and total RAM consumtion is for example 10 GB. On property change 1 GB is consumed and total consumption is 11 GB, and so on. Spotfire just adds GB and on property change no RAM is released. With lots of property changes sooner or later RAM is used and disk engaged and from that point on Spotfire is stuck. All the caching can be disabled - on data connection and withing data on demand data loading setting but the result is the same.
Question: why does Spotfire consumes RAM in a cumulative way on each property change? The point of fetching data with on demand setting and property is effective way of fetching data to dxp to optimize data loading and RAM consumption. On property change no old data is needed anymore (when not cached). Is there a way how to release RAM in this case? The only way I can do that now is to close the Spotfire session. Even closing the file (withouth closing the client) does not release total RAM used by that dxp.