Datasource too slow when refresh data after big data loaded

Datasource too slow when refresh data after big data loaded

Posted by: marianrs89 on 27 January 2021, 12:48 am EST

• 

  marianrs89

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 January 2021, 12:48 am EST

  Hi,
  
  When I assign a datasource to the flexgrid with 15000 rows and then refresh the data and assign one with 288 it is very slow the assignment the second time. Is it possible that there is something cached on the datagrid?How could I make this assignment faster?

  Regards

• 

  kartik.sagar

  

  • Post Options:
  • Link
    Copy

  Posted 27 January 2021, 11:24 pm EST

  Hi Marian,

  I am not sure whether you are using FlexGrid or DataGrid. However, I have tried loading 50k rows in both DataGrid and FlexGrid but I have’t noticed any speed issue while changing the source. Please refer to the same from the attached sample. (see FlexGridLargeData.zip)

  Is it possible that there is something cached on the datagrid?

  No DataGrid/Flexgrid doesn’t caches the data.

  If possible could you please make the necessary changes in the attached sample in order to replicate this behavior?

  And also please share the C1 version you are using.

  Regards,
  
  Kartik

  FlexGridLargeData.zip

• 

  marianrs89

  • Post Options:
  • Link
    Copy

  Posted 28 January 2021, 12:55 am EST

  Hi,
  
  I’m using the version 4.4.6.20133.796 of C1FlexGrid. I use flexgrid and I assign the data to the DataSource that is assigned in a BindingList.

  fgList is my C1FlexGrid and bhRS my BindingList:

  fgList.DrawMode = DrawModeEnum.OwnerDraw
  
  fgList.DataSource = bhRS
  
  fgList.DrawMode = DrawModeEnum.Normal

  I need to do some things in the event OwnerDrawCell. Yesterday I had “AllowMerging” set to Custom before set the DataSource and I changed to None and seems that works faster but I don’t know if this was the problem.

  My version doesn’t have ItemsSource property. I’m using .NET Framework 4.5.2.

  Regards,
  
  Marian

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 31 January 2021, 6:35 pm EST

  Hi,
  
  We do not see this issue at our end, please refer to the sample and gif attached. We suggest you try BeginUpdate() and EndUpdate() methods to improve optimization.
  
  For more info on BeginUpdate and EndUpdate visit https://www.grapecity.com/componentone/docs/win/online-flexgrid/C1.Win.FlexGrid.5~C1.Win.FlexGrid.C1FlexGridBase~BeginUpdate.html?highlight=beginupdate%2C.

  
  fgList.BeginUpdate()
  fgList.DrawMode = DrawModeEnum.OwnerDraw
  fgList.DataSource = bhRS
  fgList.DrawMode = DrawModeEnum.Normal
  fgList.EndUpdate()
  

  The version you are using is very old and since then FlexGrid have received a lot of improvements, we suggest you try after updating your controls to the latest version.
  
  If you still face the issue, we request you to provide a sample replicating the issue so that we can investigate this issue.
  
  Regards,
  
  Prabhat Sharma.
  
  FgDataSource.zip[img]https://gccontent.blob.core.windows.net/forum-uploads/file-211b8187-600c-49ce-9abd-adc41033f340.gif[/img]