Performance Guidelines

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

  • Posted 8 September 2017, 2:01 pm EST

    <P>Hi,</P>
    <P>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.</P>
    <P>Do you have any general guidelines or best practices that we can follow inorder to achieve some performance gain?</P>
    <P>Thank you!</P>
    <P> Regards</P>
    <P>Mahesh</P>
  • Replied 8 September 2017, 2:01 pm EST

    <p>Hello Mahesh,</p><p>There are no such performance issues reported using Spread for Windows Forms while working with DataBase.</p><p>However, sometimes the Style applied and the Amount of the data to be displayed in Spread may create a little bit of difference.<br></p><p>Making some <font color="#0000ff">Settings</font>  in Spread while fetching Data might give you a different result.</p><p> </p><p>Thanks,</p><p> </p><p> </p>
  • Replied 8 September 2017, 2:01 pm EST

    <P>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?</P>
    <P> Thank you</P>
    <P> </P>
  • Replied 8 September 2017, 2:01 pm EST

    <p>Hello,</p><p><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></p><p> </p><p>Thanks,</p><p> </p><p><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;"><br></span></span></font></p><p> </p>
Need extra support?

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

Learn More

Forum Channels