Large number of rows with individual column filtering dropdowns

coolboyjules

Hi everyone,

I currently have a client-sourced table (debug code: uniqed) with individual column select drop-downs that work amazing. I have about 1000 rows and the performance is great. Amazing jQuery plug-in. Problem: my client just told me that this could grow to upwards of 40000 in a month. My client also told me that they really like the individual select filters in the footers and I can't remove them. Hence, I am worried about performance. See here if you don't know what I'm talking about when I say individual select filters:

https://datatables.net/examples/api/multi_filter_select.html

I was poking around and I saw the example here using client side and deferred rendering:

https://datatables.net/extensions/scroller/examples/initialisation/large_js_source.html

But the issue is I don't believe I can use deferred rendering since the client wants the individual select filters. I have to load up all the data for the select filters to even work...

Does anyone have any idea how I can accomplish this behavior of individual column filtering with good speed at high number of rows? I feel like I am reaching the limitations of the software/browser here...

Thanks!

Julian

tangerine

@Julian: Am I understanding this correctly: 40,000 items in dropdown select filters?!
I think you'll have to change your client's mind. Server-side processing with text input select filters would do the job for you.

allan

Yup - server-side processing is the way forward for large data sets.

Allan

coolboyjules

Sadly I figured this was the case. I will try to change the client's mind and suggest server side processing with search inputs. I believe that is the only way to achieve close to the functionality they are looking for.

Thanks everyone.