Server Side Data table is very slow
# July 14, 2013 at 2:42 pm
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.
What should I do# July 14, 2013 at 4:24 pm
umm it is required to load all data but what i have in mind is that it loads 10 entries and when clicked on next page it loads 10 next entries, same when searched it searches all data.
i guess I am making sense
Edit : No i dont want to cache data as it is kind of sensitive with all names , address and phone numbers etc.# July 14, 2013 at 4:36 pm
This reply has been reported for inappropriate content.
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.
You must be logged in to reply to this topic.