2 million records
2 million records
npr_new
Posts: 3Questions: 2Answers: 0
Hi, I am creating datatable using stored procedure and generic handler. i was able to create it but the paging of the total records is not correct. it seems that it rounds of the total records specially i have 2M plus records.
Also, is there a way i can speed up the loading?
This discussion has been closed.
Answers
This section of the FAQ should help, it discusses various techniques to improve performance,
Cheers,
Colin
Hi Colin, thanks for your response. I check your link and that is already what I have design on my datatable but it still slow on displaying on every page and on search. Since i have 2 millions plus records, is there other way to speed up? Every page or search, it display around almost 2 mins.
If you're using
serverSide(mentioned in that FAQ page), it should be considerably less. If it is that long, you'll need to profile the page - for example, is the time taken in the network, on the client, on the server's DB queries?Colin
2,751,439 records at ten records per page produces 275,144 pages.