I have a page on my site that displays all the customers list for our clients, i am currently using JQuery Data table plugin for pagination, searching and sorting. It works fine except one problem ‘data loading’. It loads 3000′s of rows from the sql database and populates the table, then apply the jquery plugins for searching, sorting and pagination. This process takes 10 seconds Offline and much more online.
and over this the table has to be loaded again and again for various reasons.
Then I think the better way to load the data is on demand. I don’t know how the plugin works, but if you only want 10 entries at a time, ask for just those 10 entries from the database, since the slowness is to a large extent (likely) to do with the many rows it’s needing to load.