Browser become irresponsive when more than 50000 records bind with datatable

Kirangarwa

I have created an application in which I have used datatables and handler for binding data with datatable where I have used JSON dataformat.

When I request for the data First time all 100,000 records come in the datatable which is client side but when I click second time at datatable creation it will not execute the further code and browser become irresponsive and hanged.

ignignokt

I believe I've seen Allan suggest many times that once you hit 50,000 you should switch to server-side. He would probably have a better explanation of exactly why.

I don't see a reason to actually load all 100,000 records with every page load since server-side simulates having them all loaded anyway, without actually loading them.

allan

Yes indeed! I would suggest taking a look at the FAQs.

Allan

Kirangarwa

Thanks for your precious time. I got the answer. I am clearing the table data at every find click by using fncleartable().