Dealing with millions of records in DataTable

rajarajananis

Hello all,

First of all, I wanna say thanks for your(Allan, arrow) answers my previous post. that would be really nice.

So, please help me on this issue too. It might be easy for you people because I just started using Data Table plugin now. OK here is my question

I am working converting ASP.NET grids to DataTable plugin. The issue is my production server has millions of records need to be handled in Data-table, that might be more than 2 lakhs. I fetch data from server side through Ajax calls. The issue is DataTable throws an error like "A script on this page maybe busy or , it may have stopped responding.." and , the error has three buttons say "Continue", "Debug Script", and "Stop script". So, If want to handle millions of records which way would be preferable ?. If server side, is it possible in C#? when you say server side, the paging , sorting and rest of the features need to be handled on server? if so , c# meets this ?

Please clarify it. I am totally confused it. And last but not least, can you tell me how many records DataTable can handle in Client side (Approx ) ?

And, I know you people are very busy responding answers, but, If you response on this then I have no words to say !!thanks!!

!!Please!!

Regards
Raja.S

rajarajananis

Allan,

Any updates please...

Regards
Raja.S

mimiko

rajarajananis, do you show all this millions of records to client at once? Does the client need to view all of this records at a time? May be minimising the number of records will be more efficient?

As I understand, Datatable can handle millions of records. Its up to clients procesing power to handle so much data in a short time.

My advise is to give to clients as low data, as they need. You may use any server side scripting language.

rajarajananis

Thanks mimiko for your help. I will ask my queries ASAP.

allan

Sounds like you need to use server-side processing, which is documented here: http://datatables.net/usage/server-side . That will handle many millions of rows no problem (assuming your server can cope with your script - it should!).

Allan

rajarajananis

Thanks Allan, I will go through it and keep you updated.