Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.

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