Best way to load 500,000+ items?

RemiDG

That's a lot indeed. I was wondering what would be the best way to let Datatables handle such an amount of records. I basically need to choose between a serverside script that returns 50 records for you each time, or just give the Datatables one big JS array of all records. Of course I will only display 50 records. I may also need to look into optimizations, I understand that such an amount of records could give some trouble. Any ideas?

allan

Use server-side processing. That will cope with millions of rows no problem (assuming the server-side script isn't doing some mad processing of course!).

Allan