RFE : Performance improvement for "sample real-time data source" plugin with large data set and large calcutation
Background: i am using gnumeric and its great "sample real-time data source" plugin. Basically i have built a datasheet into which i automatically feed hundreds of new key-values each day. My issue is that the time processing is getting worse and worse as time goes on and the data set goes larger. It currently takes more than one hour for a full load.
Of course, i could try to optimize things a bit but a better approach might be sensible : As long as i understand how things go on, the automatic calculation is performed after each key-value loading. To put in with figures : if i disable automatic calculation, data are loaded in 2'30s Then, a manual calculation took a few seconds
Of course, i could just maually disable automatic calculation each time i load data. whether temporary or permanently, it wouldn't be very convenient.
RFE: i was wondering if it would be possible to automatically disable calculations for a few seconds each time a new data is loaded from "sample real-time data source" plugin and its atl_last function. A duration of one second would probably be big enough for a script to load the next value and reset the counter. The calculation would be performed only once when all data are loaded.
It would be really great and i can't really think of any drawback from an end user point of view. What do you think ?
Thanks for reading.