System.OutOfMemoryException when loading huge data

System.OutOfMemoryException when loading huge data

Posted by: salams on 29 April 2018, 8:33 am EST

• 

  salams

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 April 2018, 8:33 am EST

  hi
  
  i got error message when i try to load to C1FlexGridClassic 4132904 rows using moFlex.DataSource=getdata().
  
  i receivedthe error at moFlex.EndUpdate();
  
  the following error message :
  
  “Cross-thread operation not valid: Control ‘VSFlexGridMembers’ accessed from a thread other than the thread it was created on.”
  
  and “System.OutOfMemoryException”

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 30 April 2018, 5:33 am EST

  Hello Salam,

  Loading 4,133,000*10 records, I do not observe any OutOfMemoryException at my end using the latest C1 version 2018v1, what version are you using?
  
  Also, as I understand the issue might be related to the amount of system memory available while loading such huge data and/or also, on the type of data you are loading in these ~4,133,000 records, I tried with simple integer/string data for each cell.
  
  So, could you share a stripped down version of your application so that we can test the issue at our end and help you further

  Thanks,
  
  Ruchir Agarwal

• 

  salams

  • Post Options:
  • Link
    Copy

  Posted 2 May 2018, 6:54 am EST

  WindowsFormsApplication8_spilt.zip

  hi
  
  i re attached the files again

• 

  salams

  • Post Options:
  • Link
    Copy

  Posted 2 May 2018, 7:04 am EST

  query1 (4).zip
  
  this is the csv file
  
  please duplicate the rows inside until you got the rows count that we want (~20000) for check the Performance and 4 million rows to check the out of memory exception

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 3 May 2018, 7:47 am EST

  Hello Salam,

  Thank you for sharing the sample application.
  
  However, as I can see you are discussing the same issue over another case, where we have responded to your concerns: https://www.grapecity.com/en/forums/c1-studio/how-to-implementing-the-vi
  
  Hence, I would request you to please refer the same for further discussion over the issue.

  Regards,
  
  Ruchir Agarwal