Saving xml files

Saving xml files

Posted by: grapecity on 13 February 2018, 10:01 am EST

• 

  grapecity

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 February 2018, 10:01 am EST

  In our application we are saving large amounts of data, formulas and formatting information to the .xml file with the following line of code;

  frmMain.spdProj.Save(Trim(FirmCompanyOptions.CompanyFolder) & Trim(spdProj_SetupOpt.SpreadFileName) & “.xml”, False)

  These .xml files can be in excess of 100MB.

  We have noticed that when you save the .xml file more than once without exiting the application the save time increases upon subsequent saves. For example, for a series of 3 consecutive saves without doing any other actions the save times were as follows;

  First save 8 seconds
  
  Second save – 50 seconds
  
  Third save – 70 seconds

  The file being saved was about 150mb.

  Do you have any ideas as to why this is happening? If it is memory leakage, is there any way to resolve it?

  Thanks

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 16 February 2018, 4:12 am EST

  Thanks for your response. Any ideas as to how long it usually takes to get a response?
  
  Ed

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 19 February 2018, 4:45 pm EST

  Hello,

  I am able to replicate the problem at our end. I have escalated this to the development team(Tracking Id 254620) and will revert you back once have any information from them.

  Thanks
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 February 2018, 5:44 pm EST

  Hello Ed,

  On analysing more, we found that this issue occurs due to visual studio debugger effect. It will slow down processes a lot, especially processes which are creating very many objects and then discarding them for cleanup by the GC.
  
  Please refer the attached sample. Could you please check after executing the application in Release configuration?

  If issue still occurs could you please either modify the attached application or provide your own stripped down project so that we can try reproducing the same behaviour at our end and assist you further accordingly?

  Thanks,
  
  Mohit

  SavingXMLFiles2.zip