processing 10000 records is taking a long time

[PayalY]

In my code,10000 record and 23 columns so tabulator take 2 minutes to bind it .There is any solution to bind a data in seconds

[olifolkerd]

Hey @PayalY

That depends a lot on how your table is configured, but it shouldnt take that long to load.

Could you post a copy of your table constructor so we can see how your table is setup, we can then offer some advice.

Cheers

Oli :)

[PayalY]

$("#Indenttable").tabulator({ height: 500, tooltips: true, tooltipsHeader: true, index: "Id", columns: [ // { title: "Status", field: "Status", formatter: "textarea", align: "Center", headerFilter: "input", align: "center", visible: false },

{ title: "Select", field: "Id", width: 42, align: "center", frozen: true, formatter: function (cell, formatterParams) { var row = cell.getValue(); return "

"; //return the contents of the cell; }, },

{ title: "", field: "indstatus", visible: true, width: 70, align: "Center", headerFilter: "input", formatter: function (cell, formatterParams) { var value = cell.getValue(); if (value == "In progress") { return ""; } else if (value == "GRN done after commitment") { return ""; } else if (value == "GRN done on/before commitment") { return ""; } else if (value == "Commited date is crossed") { return ""; } }, }, { title: "Part code", field: "Pcode_code", formatter: "textarea", width: 190, headerFilter: "input", align: "left" }, { title: "Description", field: "Pcode_Description", formatter: "textarea",width: 282, align: "left", headerFilter: "input", visible: false }, { title: "Cost Center", field: "cost", width: 70, headerFilter: "input" }, { title: "Qty UOM", field: "UOM", width: 60, headerFilter: "input" }, { title: "Status", field: "strstatus", width: 140, headerFilter: "input" , formatter: function (cell, formatterParams) { var value = cell.getValue(); return "" + value + ""; }, }, { title: "Indent Date", field: "SavedOn", width: 81, align: "Center", headerFilter: "input", align: "left" }, { title: "Req.Date", field: "date", width: 76, align: "Center", headerFilter: "input", align: "left" }, { title: "Commited Date", field: "strCommitedDate", width: 76, align: "Center", headerFilter: "input", align: "left" }, { title: "PO Date", field: "PODate", width: 76, align: "Center", headerFilter: "input", align: "left" }, { title: "GRN Date", field: "GRNdate", width: 76, align: "Center", headerFilter: "input", align: "left" }, { title: "Last Updated On", field: "UpdatedOn", width: 84, align: "Center", headerFilter: "input", align: "left" }, { title: "Indent No", field: "Id1", width: 58, align: "Center", headerFilter: "input", align: "left" , formatter: function (cell, formatterParams) { var value = cell.getValue(); return "" + value + ""; }, }, { title: "PO No", field: "PONo", width: 166, align: "Center", headerFilter: "input", align: "left" }, { title: "Vendor Name", field: "VendorName", width: 166, align: "Center", headerFilter: "input", align: "left" }, { title: "Indenter", field: "username1", width: 100, align: "Center", headerFilter: "input", align: "left", visible: false }, { title: "Last Updated By", field: "username", width: 71, align: "Center", headerFilter: "input", align: "left" }, { title: "Id", field: "Id", width: 43, align: "Center", headerFilter: "input", align: "left", visible: false }, { title: "Division", field: "DivisionName", width: 88, align: "Center", headerFilter: "input", align: "left", visible: false }, { title: "SCM remarks", field: "Remarks1", width: 150, align: "Center", headerFilter: "input", align: "left" }, { title: "Location", field: "location", width: 88, align: "Center", headerFilter: "input", align: "left" }, { title: "Indent Remarks", field: "PartRemarks", headerFilter: "input", width: 150, align: "left" }, { title: "Indenter's Remarks", field: "Indenterrmk", headerFilter: "input", width: 150, align: "left" }, { title: "Expected date", field: "strExpectedDate", width: 88, align: "Center", headerFilter: "input", align: "left", visible: false }, { title: "Assembly status", field: "AssStatus", width: 88, /align: "Center",/ /headerFilter: "input", align: "left",/ editor: AssemblyEditor }, { title: "cnt", field: "cnt", width: 30, visible: false, formatter: function (cell, formatterParams) { document.getElementById("hdncnt").value = cell.getValue();

}, },

], });

----- Original Message -----

From: "Oli Folkerd" notifications@github.com To: "olifolkerd/tabulator" tabulator@noreply.github.com Cc: "PayalY" payal.yeola@armstrongltd.in, "Mention" mention@noreply.github.com Sent: Sunday, August 5, 2018 7:20:05 PM Subject: Re: [olifolkerd/tabulator] Tabulator (#1308)

Hey @PayalY

That depends a lot on how your table is configured, but it shouldnt take that long to load.

Could you post a copy of your table constructor so we can see how your table is setup, we can then offer some advice.

Cheers

Oli :)

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub , or mute the thread .

[olifolkerd]

Hey @PayalY

How are you setting the data on your table?

Cheers

Oli :)

[PayalY]

Hey olifolkerd ,

My data is come from the database and return a JSON data then set a tabulator using following function

$.ajax({ url: "R_frmIndentTracker2.aspx/FetchTracker", method: 'Post', data: "{'costcenter':'" + document.getElementById('ddlcostcenter').value + "','Indenter':'" + document.getElementById('ddlindenter').value + "','Status':'" + message + "','jobcodenewP':'" + document.getElementById('ddlprojectcode').value + "','Id':'" + 0 + "'}", contentType: "application/json; charset=utf-8", dataType: "json", success: function (r) { $("#Indenttable").tabulator("setData", r.d); document.getElementById('divloader').style.display = 'None'; } });

----- Original Message -----

From: "Oli Folkerd" notifications@github.com To: "olifolkerd/tabulator" tabulator@noreply.github.com Cc: "PayalY" payal.yeola@armstrongltd.in, "Mention" mention@noreply.github.com Sent: Tuesday, August 7, 2018 10:44:06 PM Subject: Re: [olifolkerd/tabulator] Tabulator (#1308)

Hey @PayalY

How are you setting the data on your table?

Cheers

Oli :)

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub , or mute the thread .

[olifolkerd]

Have you check to see weather it is the request that is taking a long time to return, or Tabulator taking a long time to process the data?

[PayalY]

Yes, i have check tabulator taking a long time to process the data

----- Original Message -----

From: "Oli Folkerd" notifications@github.com To: "olifolkerd/tabulator" tabulator@noreply.github.com Cc: "PayalY" payal.yeola@armstrongltd.in, "Mention" mention@noreply.github.com Sent: Saturday, August 11, 2018 2:02:10 AM Subject: Re: [olifolkerd/tabulator] Tabulator (#1308)

Have you check to see weather it is the request that is taking a long time to return, or Tabulator taking a long time to process the data?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub , or mute the thread .

[olifolkerd]

Hey All,

To make it easier to notify everyone of progress with the rendering system i have created one issue #1437 where i will report progress.

Cheers

Oli :)