"Unresponsive script" warning on large data set.

fitsum80

I have been using the datatables more than a year and it's been working like a charm. But now when I start using it for a large data set I got "Warning: Unresponsive Script" message for about 8,000 records. I tried to disabled the sorting feature but it doesn't seems help. Please help!

Fitsum

GregP

I'm not personally aware of any way that you can fix this with a quick parameter change. It's reporting back the truth-- the script is taking too long. Even if it's a browser preference, you'll never be able to get all your end users to update that preference.

The 'real' solution is to request a smaller data set, which will mean switching to server-side processing. This is really what the server-side functions were meant for-- pagination, searching, sorting-- all are variables sent to the server to do the job and then return a smaller data set. DOM-based sorting will never be as fast as an actual SQL (or any other database) sort.

Check it out: http://www.datatables.net/usage/server-side

You'll find a huge number of DataTables users are using server-side processing, so you should be able to get plenty of help along the way.