Capabilities of datatables to handle huge amount of data

vinayganeshh

I have about 1 million rows of data on my FileMaker data which i would want to display on the datatable. I would want to use the multi column filter datatable which is in the link below instead of querying the database and filling the database up. is it a good idea to populate the datatable with the whole data and then filter it using the datatables native functionality ? Is it capable of handling it ?

http://datatables.net/release-datatables/examples/api/multi_filter.html

allan

I would suggest using server-side processing with 1 million rows: http://datatables.net/faqs#speed . I've seen tables which use 20 million + rows with server-side processing, but I think you'd be really pushing the browser to do it client-side.

Allan