2 million records

npr_new

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?

colin

This section of the FAQ should help, it discusses various techniques to improve performance,

Cheers,

Colin

npr_new

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.

colin

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

tangerine

the paging of the total records is not correct

2,751,439 records at ten records per page produces 275,144 pages.