Spread JS - fromJSON api preformance improvement

Posted by: rohit.wagh on 13 May 2020, 1:14 am EST

    • Post Options:
    • Link

    Posted 13 May 2020, 1:14 am EST

    Hi,

    We have 7.4 MB ssjson file for Spread JS 13, and when loading this file using fromJSON api, it takes around 8-9 seconds.

    This is after using below features to improve performance.

    • “spread.isPaintSuspended

      spread.suspendCalcService

      spread.suspendEvent”

    Using above features have improved the performance for us, but we still need to reduce the time taken to load JSON into Spread JS.

    Please can you help us understand or point out to any specifics that can be done to improve fromJSON performance.

  • Posted 13 May 2020, 5:52 pm EST

    Hi Rohit,

    If your sheet also contains a lot of formulas, you may use the doNotRecalculateAfterLoad flag to improve load performance a bit.

    https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Workbook~fromJSON.html

    Another option you could try to improve calc performance is set calcOnDemand to true:

    spread.options.calcOnDesmand = true;
    

    Regard

    Sharad

Need extra support?

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

Learn More

Forum Channels