I am developing asp.net application that returns table of information.
The database the company use is big. When I say big I mean 5000000 million records for a table.
After a research I found some nice js framework to use (https://docs.handsontable.com
I return JSON data and show on the table, but the issue is when I have big data it goes out of memory.
My question is:
How do I return data efficiently with ajax call?
How do I handle this amount of return?
If you suggest it is paging, then tell me how can I do it through the UI and serverside implementation.