Setting some properties of each cell is too slow in 14.45.20213.0 version

Setting some properties of each cell is too slow in 14.45.20213.0 version

Posted by: lee.hs on 15 April 2022, 6:21 pm EST

• 

  lee.hs

  • Post Options:
  • Link
    Copy

  Posted 15 April 2022, 6:21 pm EST

  Hi,

  We had upgraded Farpoint Spread to 14.45.20213.0 from 4.0.3512.2008 in this year.
  
  With same cases, their are such a massive gap in performance between them.

  Example)
  
  Conditions : 103 Columns / 430 rows

  Setting BackColor for each cell takes 00:00:00.0000020~30 in old ver.
  
  Setting BackColor for each cell takes about 00:00:00.0001021~33025 in new ver.

  Setting Renderer, NoteIndicatorColor are seriously slow too.

  It seems more data take more times for setting each cell`s properties.

  Could you guide us what makes these get so much slower than old ver.?

  Thanks,

  Lee

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 17 April 2022, 5:00 pm EST

  Hi Lee,

  Could you please share a small sample replicating how you are setting the properties for these cells? We check for a range of 103 columns and 430 rows and got similar results in both versions. Please share a sample so that we can investigate further at our end.

  Regards
  
  Avnish

• 

  lee.hs

  • Post Options:
  • Link
    Copy

  Posted 18 April 2022, 1:54 pm EST

  Hi Avnish,

  Thanks for your reply.

  I made a sample and uploaded to the link below.
  
  https://drive.google.com/file/d/1LpTTtn76dI5jb2wNldJQOYs8F71TfYeB/view?usp=sharing

  The sample looks quite messy(sorry), but only you need to see is
  
  [TSpreadGrid.cs - line 288]
  
  cell.Renderer = renderer as IRenderer;

  During make this sample, we figured out that setting [cell.Renderer] makes all these performance gaps.

  Here is the steps.

  1. Run this sample.
  2. Maximize the Winform.
  3. Do auto sorting with the [InVoy] column twice.
  4. See the performance and output prompt logs.(There is time elapse for setting cell`s fore/back colors.)

  Guide video is here.
  
  https://drive.google.com/file/d/1Q9CHEa9MGTnPPpp-A9juEf0QdWkWu-rl/view?usp=sharing

  When you delete [TSpreadGrid.cs - line 288], you would see it much get faster.
  
  Our [CodeRenderer] do nothing further in here, and even while do something, it was not a problem with old ver.

  I hope it would be helpful.

  Thanks,
  
  Lee

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 April 2022, 2:33 pm EST

  Hi Lee,

  We could not access the files using the links you provided. We have created a case on our support portal [Case ID: CAS-30669-K8R8S1]. Please continue the thread there.

  You can find your support cases in the “My Support” section of your grapecity account.
  
  Link: https://www.grapecity.com/my-account/my-support

  Regards
  
  Avnish