Large dataset filtering from custom data


I do have a large dataset I need to aply filters to with a filter panel:

When I load the data as custom data so I can aply checkbox filters, I guess I having memory problems probably because i passing it as a Json

What would be a good way to do this filtering?

How can I load the data afer I apply the filters so no need to load so much data.

400 rows is not very many. What memory problem do you see?

You could do the filtering in SQL.

How to do the filtering in SQL from the checkboxes?

This may be a good solution because there are many parameters to filter.

1 Like