JQUERY plugin for Ajax request , table sorter and pagination
In one of my application I am using JQUERY table sorter plugin and it's addon pager also to do pagination. To use this initially I am querying database which contains huge data. Once it is queried then I am looping through the query and display in front end. Then I am applying JQUERY table sorter and pager. Now columns are sorting properly and pagination is also working. My problem is as it is a huge query I may get time out error and hence table sorter and pagination will not work. As a work around I am looking for JQUERY plugin which can do pagination in such a way that it will fetch chunk of dat from database.For example I clicked on a next link in the first page then Ajax request will go to server and fetching number of records selected in the first page. And I need to do table sorting as well in each page. Can any one help me find out a plugin matching this requirement. Your timely help is well appreciated. Thanks in advance.