Hi, I have been looking for a faster method to display the data in phpLD and I was wondering if there are any special considerations when we have 1000, 10000, or even 100000 records in a table.
I've had reports that DataTables is still quite usable when displaying 100'000 records (the limit will be using loads of Javascript RAM...). I would suggest trying it and seeing what happens and let us know!
One other thing, you can disable the sorting classes (which highlights the columns which are being sorted upon) using bSortClasses, which can give a significant performance boost ((since it doesn't need to muck around with adding and removing classes):
http://datatables.net/usage#bSortClasses
Great, thanks for your prompt reply. We may try this on phpLD. Hopefully, in the next couple of weeks we can fit this into our schedule to give it a try. I really like what you have here. It's surely better than what we have now in our admin for phpLD.
Replies
I've had reports that DataTables is still quite usable when displaying 100'000 records (the limit will be using loads of Javascript RAM...). I would suggest trying it and seeing what happens and let us know!
One other thing, you can disable the sorting classes (which highlights the columns which are being sorted upon) using bSortClasses, which can give a significant performance boost ((since it doesn't need to muck around with adding and removing classes):
http://datatables.net/usage#bSortClasses
Allan
Allan