Sheet CallBack() performance

Sheet CallBack() performance

Posted by: Javier.Rapoport on 10 October 2017, 7:57 am EST

• 

  Javier.Rapoport

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 October 2017, 7:57 am EST

  When posting data back to the server, we are seeing times of 30 seconds or longer between calling CallBack() in JavaScript and the first breakpoint on the server side.

  We are using Spread 9.4 with .NET MVC3 and our sheet contains about 80 columns and 900 rows.

  Any ideas for improving performance?

  JS:

  
  sheet..UpdatePostbackData(); 
  sheet.CallBack('Export', true); 
  
  

  C#:

  
          protected void ButtonCommand(object sender, SpreadCommandEventArgs e, SheetCommands shtCmds)
          {
              FpSpread spread = (FpSpread)sender;
  // ...
  }
  
  

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 11 October 2017, 1:49 am EST

  Hello,

  Performance of the Ajax call back depends on the size of the page. You should see that reducing the amount of data on the page should make the upate faster. Saving the State into a Session variable should make the outputted source to the client smaller and the AJAX callback time quicker than when you left it at default of saving to the ViewState. Is that what you are seeing? If so, you can make the outputted page source even smaller by setting the RenderCSSClass property of the Spread to True.

  If you are still having troubles, could you post a small zipped project reproducing the issue for us to debug?

  Thanks,
  
  Deepak Sharma

• 

  Javier.Rapoport

  • Post Options:
  • Link
    Copy

  Posted 11 October 2017, 4:00 am EST

  Thank you for the reply, Deepak! We will look into saving the State into the Session.

  I looked at RenderCSSClass but that property is already true by default when I debug into our Load function.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 12 October 2017, 2:21 am EST

  Hello,

  Good to know that you have already set the RenderCSSClass property set to true. Please let me know if saving the state object into Session helps you improve the performance.

  Thanks,
  
  Deepak Sharma