Slow Pivot Table Performance

Slow Pivot Table Performance

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

• 

  harry.feldman

  • Post Options:
  • Link
    Copy

  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.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  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