Is using filter date reccomended for reduce huge load data on a table?

1

Hi,

I have a question about Grist’s performance. If a table contains around 10,000 rows with many formula columns, does applying a date filter (for example, limiting the view to only today’s and yesterday’s records) reduce the amount of data that Grist loads and calculates?

Or are all rows still loaded and evaluated first, with the filter only affecting what is displayed?

I’m trying to understand whether using date filters is an effective way to improve performance when working with large datasets.

2

I’m fairly sure that filtering does not reduce load, unfortunately. Grist loads everything up front and there’s no way around this that I know of. There used to be an option to make a table “on-demand” but that has since been deprecated, see here.