first of glad use datatables - easy use , nice solution if have work tables in html pages. when table 700 rows , 10 cols great!
but table 3000 records (rows) , maybe 10 rows , performance of search dramatically decreased. updated version of datatables.js script 1.9.4 1.10.7 - see no changes in speed while searching in table. tried pagination enabled or disabled - no difference.
what can done increase performance , speed of search? abolutely sure 3000 records not big deal great library datatables!
update use static page , tabletools add-on. options are
"sdom": 't<"clear">lfrtip', "otabletools": {***tabletools options**}, "spaginationtype": "full_numbers", "bpaginate": true, "idisplaylength": 30, "blengthchange": false, "binfo": true, "olanguage": { *** translations *** }
load data asynchronously, each page retrieval new request server. solve searching issues (...given write queries properly.) :
datatables server-side processing example.
i'm running datatables 100k records, no issues here.
good luck!
Comments
Post a Comment