Grid data add a lot of rows bug

Suite and Optimus Optimus
#1

Hi,
I’m trying to load 50’000 rows in a grid table, the issue is that the table freeze and not allow to use page.
I use your function dataAddRow to

here the code
function addGridRowsNoLoaded(total, nbRow=1000) { let time = (new Date()).getTime(), totalRow = (total >= nbRow? nbRow:total), rows = []; total = total- totalRow; for (let l = 0; l < totalRow; l++) { rows.push({ id: "ux"+(time+''+l) }) } if (rows.length > 0) { grid.data.add(rows); } if (total > 0) { setTimeout(() => { addGridRowsNoLoaded(total, nbRow) }, 500) } }

addGridRowsNoLoaded(50'000, 1000)

Can you help use to understand how we can add a lot of row without to occured errors.
Many thanks
Franck

#2

Hi @franck.fasano,

Looks like I already answered it through support system, but in case if somebody else will face the same issue will repeat answer here:

The add method is designed to add single rows, and in case of adding multiple rows (like 50’000 rows) it will highly decrease performance.

In your case, it’s better (and suggested) approach is to use the parse method:

Here is an example:

https://snippet.dhtmlx.com/fj7xnact

Kind regards,