Loading time of Data table is very slow

Sreyas

https://appresh.sreyassolutions.com/mportal/merchants/admin/view_authorization_code1.php
In the above page I using datatables to load 10 lakhs data from the database. I using the server side processing to display the data. But when I open the above page the data shows within 5 seconds. when I click on the second page, the data shows within 5 seconds. But when I click the last page, the data shows after 30 secs. I want to show the data within 5 seconds.

Please help to resolve this issue.

colin

That'll be down to the performance of the server-side script - DataTables is just waiting for a response from your server. (thanks for the test case to confirm that). Because of that, you'll need to optimise that server-side script to reduce those responses.

Colin