Pivot grid performance issue with real time data update

Answered
Amar asked on November 7, 2024

Hi Team,

I am using 2.9.88 trial version of flex monster. Currently I am facing memory problem with data update.
My data set is of near about 16,000 rows with 100 columns. I am showing pivot with 6 hierarchy levels and 10 measures.
On interval of 4 seconds, I update data as per below code.

 this.pivot.flexmonster.updateData({
        mapping: this.mappingList,
        data: dataSource
    });

My memory gets spike by near about 20 MB on every update, and it is increasing up to 1 GB and then it is stable or gets bit lower.
I do not update data if browser in minimized, in this case memory gets free but not when my pivot is in focus.

Please suggest.

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 8, 2024

Hello, Amar!

Thank you for reaching out to us.

Our team suggests two approaches for the described case:

1) Load your data as a JSON file and provide the URL to the file in the dataSource.filename property: https://jsfiddle.net/flexmonster/ac9wn6sq/.

2) Use the setReport() API call instead of updateData() to reload the data on the grid: https://jsfiddle.net/flexmonster/nj042Ls6/.

Hope you will find our answer helpful.

Feel free to reach out to us in case of any other questions.

Kind regards,
Solomiia

 

Please login or Register to Submit Answer