Performance Guidelines

Posted by: himaheshh on 8 September 2017, 2:01 pm EST

  • Posted 8 September 2017, 2:01 pm EST


    Soon we are starting a new project and will be using the Farpoint grid(Spread for Winforms). In the last project we faced lots of performance related issues especially when the data is huge.

    Do you have any general guidelines or best practices that we can follow inorder to achieve some performance gain?

    Thank you!



  • Replied 8 September 2017, 2:01 pm EST

    Hello Mahesh,

    There are no such performance issues reported using Spread for Windows Forms while working with DataBase.

    However, sometimes the Style applied and the Amount of the data to be displayed in Spread may create a little bit of difference.

    Making some <font color="#0000ff">Settings</font>  in Spread while fetching Data might give you a different result.





  • Replied 8 September 2017, 2:01 pm EST

    You are right Deepak. Can you please advice the settings that we need to make while fetching data or binding the data to the grid?

     Thank you


  • Replied 8 September 2017, 2:01 pm EST


    <font face="arial,helvetica,sans-serif">That completely depends on what settings you have made in your DataBase however calling SuspendLayout( ) and ResumeLayout( ) methods around your code will help the performance, setting the AutoUpdateNotes, AutoCalculation and DAutoCellType Properties to False may help too.</font>




    <font face="arial,helvetica,sans-serif"> <span class="Apple-style-span" style="border-collapse:separate;font-family:Tahoma;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;"><span class="Apple-style-span" style="font-size:12px;text-align:left;">


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels