Memory Leak when loading new spreadsheets

Memory Leak when loading new spreadsheets

Posted by: asafadi on 28 January 2021, 12:19 pm EST

• 

  asafadi

  • Post Options:
  • Link
    Copy

  Posted 28 January 2021, 12:19 pm EST

  We have an application that is leveraging SpreadJS to provide spreadsheet-like functionality. We store the content in JSON, and load as our users navigate between transactional data. The user’s file vary in size between 2mb and 50mb.

  We noticed that SpreadJS has a memory leak issue that is especially noticable when dealing with larger JSON files.

  I was able to replicate the problem in the Designer demo application on your site. In the (sped up) video I am loading between 2 different 60mb JSON spreadsheets (one contains pure text and the other contains only formulas).

  In our application, these JSON files containing Formulas causes a memory leak that reaches 4GB’s after 8 loads, causing the browser to crash. The memory leak is about 400-500mb in size, varying between Text and Formula files.

  The video shows the same behavior in the Design demo application. I am including the 2 JSON files I used to replicate the issue in Designer.

• 

  asafadi

  • Post Options:
  • Link
    Copy

  Posted 28 January 2021, 12:26 pm EST - Updated 3 October 2022, 9:16 am EST

  I was unable to upload the video, so I am attaching some images of the process, along with the JSON ZIP files.

  

  1908×1076 246 KB

  

  1914×1074 246 KB

  

  1912×1076 86.8 KB

  60mbText.json.zip60mbFormula.json.zip

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 29 January 2021, 6:01 am EST

  Hi Ali,

  Thanks for the sample file. We are able to observe the issue at our end hence we have forwarded it to the concerned team for further investigation. We will update you regarding this as soon as we get any information. The internal ID for this issue will be SJS-7460.

  Regards
  
  Avinash

• 

  joe

  • Post Options:
  • Link
    Copy

  Posted 18 May 2022, 5:42 pm EST

  Hey Avinash,

  Has there been any update on this? We’ve noticed this same issue and it is having a major impact on our app’s performance

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 19 May 2022, 2:32 am EST

  Hi,

  The issue has been fixed in our latest release, Please update to the latest build(that is v15.0.7) and let me know if you still face any issues.

  Regards,
  
  Avinash

• 

  joe

  • Post Options:
  • Link
    Copy

  Posted 19 May 2022, 12:31 pm EST

  Thanks Avinash, that is great to hear