Database on another server, not in the deployment of application server,
Paging data size is 500 per page, running locally, query the first page and page 19, response speed gap is not big,
But in the server running, query the first page and 19, response speed sent more than 2 seconds,
Local - the first page
Local - 19
In the deployment server - the first page
In the deployment server - 19
Is really think along while also didn't think out what the problem is, hope everybody Daniel told,