Filtering Millions of Rows

Tags: #<Tag:0x00007f0b02aef538>

Hey Folks,

We use HOT in our software. We do not use HOT’s wonderful filter feature BECAUSE we have to filter millions or rows so cannot do the filtering on the front end. Our filter is NOT nicely integrated with the column headers :frowning: My question is have you done any investigation in integrating your filter feature WITH backend filtering so that it is possible to use your filter feature for tables with millions of rows that will not be downloaded all at once?

This would be a major evolution for our users.

Many thanks. Robert

Hi Robert,

Can you describe the process of filtering? Do you use beforeFilter / afterFilter logic? Then do you change the data via loadData or hide rows that does not much the query.