how to process record of 90000 count faster..for me its taking 2 mins of time to load

apoorvapatil

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

colin

This section of the FAQ should help, it discusses various techniques to improve performance,

Cheers,

Colin

apoorvapatil

i have a url "http://localhost:8002/static/reports/table_name/table_name.json" which returns data in json format ..and it contains 90000 records... how would it be possible to access the same using server side processing?

Lapointe

hi @apoorvapatil

What do you mean about server dside processing ? Mysql ?

Using localhost setting is for me up to 4 sec with local mysql server (wamp with 16Gb mem and ssd hard drives), when running on real MySql server less than 1 sec....

tangerine

@apoorvapatil - The basic server-side example is very simple.
https://datatables.net/examples/data_sources/server_side.html

Is that not sufficient?

apoorvapatil

Thanks everyone for your help!!! its working now...but have another one doubt, hope you all can help on the same....Now i am getting data in columns now i want to add ui-sref to the elements in the table. how can we do that?? i tried adding in html file to the td tag but its not working

colin

I'm not too clear what you're looking for - but take a look at columns.render or createdRow. Both have examples towards the end of the page that show how to add HTML or classes to the cell's data.

Colin