client side sorting performance slow with datatables

megharajn

Hi,
In our application we are using data tables plug in, the problem is when we have more than 1000's of records the page gets freeze . i .e it 's taking too much time load the results.

Right now this is what we are doing, We are fetching all records from the DB
( some time's records will be more than 10k) and while displaying we are using data tables plugin.
So kindly let me know is it right way to do or Is there any other approach.

Thanks in advance

allan

This FAQ should help: http://datatables.net/faqs#speed

Allan

megharajn

Hi Allan,
I used DataTables server-side script for pagination and sorting functionality. I am getting the database result by merging more than 2 table . in that case how can i integrate with server side.

Now its working for single table. if i use multiple table inner join how can i make it work. So please give suggestion
Thanks in advance

allan

You'd need to modify the example server-side script to do a join. There are a couple of posts in the forum about how this can be done, but basically just modify the initialisation arrays in the demo scripts.

Allan