Spread JS - fromJSON api preformance improvement

Spread JS - fromJSON api preformance improvement

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

• 

  rohit.wagh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 May 2020, 10: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.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2020, 2:52 am 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