jqxPivotGrid frozen when appending data

[anddegsParticipant]

I’m trying to evaluate jqxPivotGrid if it can able to work with my use case.

What I’m trying to do is the following.
1. Load data to jqxPivotGrid. ( 500K )
2. Incrementally Append data
3. Update existing data ( can I do this)

I noticed when I’m doing number 2, yes the data got appended
but the jqxPivotGrid window froze for some reason.

The reason I’m asking is because I’m expecting rapid data update.

I’m creating a fx pricing pivot display where data changes every seconds.

btw I used the example from this post
https://www.jqwidgets.com/community/topic/pivotgrid-data-refresh/
I changed the 5000 to 500K

[adminKeymaster]

Hi anddegs,

If you load such amount of records at once, then it is normal to freeze when it Aggregates 500K records. It will not be possible to use our component with such amount of data.

Regards,
Peter

[anddegsParticipant]

Thank you for quick response,

I understand during startup there is some slow down.

but I’m hoping during scheduled data append at the tail of the data

will not freeze the entire widget.

Does it unload and load the entire dataset again when this method code been executed ???

pivotGridInstance.refresh();

Is there an asynch way of doing data append.

Thanks

[adminKeymaster]

Hi anddegs,

The refresh method recreates HTML elements and layouts them. The component cannot load in memory such amount of records. You can update the data source or recreate the pivot only with some of the records.

Regards,
Peter

[Author]

Posts