Slow Pivot Table Performance

Posted by: harry.feldman on 12 August 2024, 3:20 pm EST

  • Posted 12 August 2024, 3:20 pm EST

    Hello,

    I’m wondering if there are any plans to optimize the pivot-table library. We’re pivoting a decently large dataset (around 20k records with 13 Row fields), and it currently takes around 10x longer to perform a pivot in SpreadJS than it does in Excel. Formatting a pivot table also takes an unreasonable amount of time for large datasets.

  • Posted 20 August 2024, 4:27 am EST

    Hi,

    We apologize for the late response. Somehow, this case was missed from our end.

    Could you kindly share us a sample file for which you are facing the issue? If the data is confidential, kindly replace it with the dummy data.

    Also, kindly share the SpreadJS Version you are using and the System Configuration on which you are running the application.

    Regards,

    Ankit

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels