Blazor wasm help
Efficient list filtering
Hi all , blazor wasm question, hoping someone might be able to help me.
I have 2 tables , companies and employees . There's about 700 companies , 10,000 employees .
I wanted to display all of the employees in a list while allowing filtering based on a few parameters. I also wanted to group the list by employer .
Struggling because virtualize doesn't seem to work if I want to collapse the groups , and also if one company has 5 people and another 20, makes it hard to virtualize that way .
Paging is one option but I wanted to be able to bulk update (each item has a selected check box )
I was hoping to load rigut into memory because 10,000 doesn't seem like a lot of rows to me but maybe it is ?
Hoping for design strats for filtering the large list so that everyone I type into a search field it doesn't take 2s to update, as well as a good way to display the items without just limiting .
1 Reply
The answer might also just be I convert my filter from an in memory filter to a search function thst hits thr db each time
Or I just paginate In memory results ? Although not sure how that'd look with group headings for the company