Spread JS - fromJSON api preformance improvement

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

  • 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.
  • Replied 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