reactgrid icon indicating copy to clipboard operation
reactgrid copied to clipboard

large data support

Open The-End-Hero opened this issue 3 years ago • 1 comments

When there are 20,000 pieces of data, the editor becomes stuck. maybe affected by react diff.

The-End-Hero avatar Sep 20 '22 09:09 The-End-Hero

Hi! Could you share some visual? What does pieces mean? Do you have 20k rows or cells? Michael

MichaelMatejko avatar Sep 20 '22 11:09 MichaelMatejko

20k rows

when you finish editing a cell and press Enter, the page is stuck for a while

The-End-Hero avatar Sep 28 '22 03:09 The-End-Hero

What do you mean by 'stuck'? What is the developer console telling you? Getting an error? Is every browser having the same issue? Is the request to the backend firing? How many DOM elements are you rendering?

What is the use case for loading 20,000 rows of data? Why won't you load a subset and based on focus point, load a range around that certain point?

MarcoDeJong avatar Sep 29 '22 07:09 MarcoDeJong

I also have problems handling large number of rows (3000). When I execute the functions on the board, there is a delay

nmdung28 avatar Oct 11 '22 09:10 nmdung28

Hi! I investigated this issue using 20 000 rows by 50 columns TestGrid. Just as you've described ReactGrid freezes after committing the cell change. I analysed the profiler and it seems that there's nothing prevalent other than the whole grid recalculating after source array update. I didn't find a way to easily optimise it in this short time, but I believe that you should be able to conditionally provide only a part of your array to avoid excessive calculations. Perhaps in the future we'll invest additional time in finding another solution, although it would most likely require significant changes, so I suppose it will be put off until the next major release.

DLowHP avatar Aug 07 '23 10:08 DLowHP

I will close this issue as there's no activity. I'm working on a new version of ReactGrid so I will take this issue into consideration and try to do my best, but I can't promise you anything yet. Such large data sets are kind of out of scope for RG - we implement virtualization, but you can get to a point when another solutions as pagination are needed to achieve acceptable performance.

DLowHP avatar Sep 07 '23 13:09 DLowHP