Posted 22 January 2018, 6:09 pm EST
Hi
Can you please help me with implementing the VirtualMode in FlexGridClassic ?
Thanks
Salam S.
How to Implementing the VirtualMode in FlexGridClassic?
Posted by: salams on 22 January 2018, 6:09 pm EST
-
salams
-
meenakshi.singh
Posted 23 January 2018, 3:57 pm EST
Hi Salam!
I would like to inform you that there is no direct way to use this grid control in virtual mode. However, C1DataSource can be used along with the grid. This control provides the feature of Virtual mode for large datasets and can be used in grid as well.
Please refer to the given help links :
- https://www.grapecity.com/en/controls/winforms/datasource
- http://help.grapecity.com/componentone/NetHelp/EFDataSource/webframe.html#VirtualDataAccess.html
- http://help.grapecity.com/componentone/NetHelp/EFDataSource/webframe.html#LargeDatasetsVirtualMode.html
- http://help.grapecity.com/componentone/NetHelp/EFDataSource/webframe.html#VirtualMode.html
Hope it helps.
Best regards,
Meenakshi -
salams
Posted 24 January 2018, 7:24 pm EST
hi
we are not using the Entity Framework , we use binding from dataset (Datatable).
is there any way to implementing the VirtualMode in FlexGridClassic? or implement other way to the load data by using the DataSource like async mode or cache ?
anything that help us to load 22000 rows in less than 20 second?thanks
Salam s. -
salams
Posted 27 January 2018, 8:54 pm EST
hi,
I found the solution that work great for me , Reduce the loading time of 22000 rows from 20 second to 1 second.here the solution :
grid.AllowResizing = AllowResizingEnum.None;
grid.AutoResize = false; -
salams
Posted 23 April 2018, 12:18 am EST
hi
is there ant chance to reduce the time less than 1 second?
thanks alot -
meenakshi.singh
Posted 24 April 2018, 1:53 am EST
Hi!
You can try using BeginUpdate and EndUpdate methods of the grid as suggested on this page :
http://help.grapecity.com/componentone/NetHelp/c1flexgrid/webframe.html#flexgridforwinformsttoptips.htmlBest regards,
Meenakshi -
salams
Posted 25 April 2018, 6:22 pm EST
hi,
1.We tried this but its not improve the loading time and still 1 second .
2.Also We saw that when there are more than 100000 rows we get “out of memory” exception.Thanks,
SalamS -
meenakshi.singh
Posted 26 April 2018, 3:44 pm EST
Hi Salam!
This much loading time seems to be okay with the large number of rows. Also, I was able to see all the rows getting loaded without any such exception. Attached is the sample that I have tried at my end :
If you see the exception with this application also, I request you to share your environment details along with the C1FlexGrid build version at your end.
Best regards,
Meenakshi -
salams
Posted 28 April 2018, 9:37 pm EST
Hi again.
see attached simple that show how much time it take to load 120000 rows from datatable
1.can you help me decreases the time to less than 1 second.
2.how to Implementing the VirtualMode in FlexGridClassic ?
3. FlexGridClassic .datasource load asynchronous ?it’s important for us to load the data fast.
thanks,
SalamS -
meenakshi.singh
Posted 29 April 2018, 10:12 pm EST
Hi Salam!
The mentioned sample is missing from your post. I request you to try re-attaching the same, so that I can assist you accordingly, at the earliest.
Regards,
Meenakshi -
salams
Posted 30 April 2018, 5:22 pm EST
hi ,
i am re-attaching the simple.
please copy the csv file into the project or fix the path so you can load it into the simple.what i am asking please is:
1.can you help me decreases the time to less than 1 second.
2.how to Implementing the VirtualMode in FlexGridClassic ?
3. FlexGridClassic .datasource load asynchronous ?it’s important for us to load the data fast.
thanks,
SalamS -
meenakshi.singh
Posted 1 May 2018, 8:57 pm EST
Hello!
Though, I am still not able to see any attachment in your latest post. Kindly make sure, the file has .zip extension only.
Also, I tried to recreate the scenario. I bound the grid with a data table having around 120000 rows and 10 columns, in it. The required methods (such as BeginUpdate/EndUpdate) and property were set as discussed above on this thread.
The loading time comes to a little less than one second at my end (tested with the latest build), while executing the statement :grid.DataSource = dt;Can you please carefully look at times taken by individual operations and confirm the loading time once?
Best regards,
Meenakshi -
salams
Posted 2 May 2018, 1:10 am EST
-
salams
Posted 2 May 2018, 1:21 am EST
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 -
salams
Posted 2 May 2018, 1:22 am EST
-
meenakshi.singh
Posted 2 May 2018, 10:22 pm EST - Updated 3 October 2022, 11:15 pm EST
Salam!
I ran your sample with the shared .csv file, with 2017-V2 as well as 2018-V1 controls. It has been a successful run (and no OutOfMemory exception) with loading time less than a second.
Can you please share the system environment details at your end? it may help me in further investigation.
Best regards,
Meenakshi -
salams
Posted 2 May 2018, 10:46 pm EST
Cpu: Intel core i7
Memory :16384mb
hd: SSD 500gbplease load 4 million 2 times rows and you will see the OutOfMemory exception.
i also ask about how decreases the time to less than 1 second.thanks ,
SalamS -
meenakshi.singh
Posted 3 May 2018, 8:54 pm EST
Thanks Salam for the details. But, I would request you to include Visual Studio version and OS details as well.
Since, I am not seeing any exception at my end with your sample. And, loading time is less than one second in the sample. It seems to be environment-specific.
Once I am able to replicate the said behaviour regarding loading time and exception, I can escalate this to the concerned team.In addition to this, are you getting this exception randomly or each time on running the sample? Please share a demonstrating video of these issues.
Thanks for your cooperation.
Regards,
Meenakshi -
salams
Posted 5 May 2018, 4:35 pm EST
hi
i am using windows 7 enterprise 64-bit
visual studio enterprise 2015
the exception happen every time i try to load it to grid.datasource (i fix this issue with building the application in 64 bit.
but i still have issue with loading 4 million rows (with 120 columns) into grid (using datasource) it take more than 10 second . -
meenakshi.singh
Posted 8 May 2018, 3:20 pm EST
Hi Salam!
Before proceeding further, I would like to summarize the above details once. You are facing two issues : Loading time, and OutOfMemory exception while trying to load data in grid.
OutOfMemory error :
1. I ran the sample that you had shared with me on this thread, successfully (Demonstrated in the image above, on this thread). I was unable to see any exception during this.
2. At your end, this exception is thrown while building your application in 32-bit, and not with 64-bit. Please let me know if this is not correct.
Also, I tried the same sample in 32-bit as well. And, there was no error during this.Loading time :
1. In the same sample shared by you, it was reported that loading time is 1 second at your end. Whereas, time consumed in loading data at my end came out to be approximately 0.30 second (which is less than a second). I had also shared a screenshot showing the same.
2. In your latest post, you have mentioned that loading time is 10 seconds for 4 million rows with 120 columns.
Here, I would need you to confirm if this loading time issue of 10 seconds is observed only with 120 columns.Kindly confirm the above points. It would help me in assisting you in the right direction. I understand your situation. But, as mentioned earlier, I need these issues to be reproduced at my end also. Once replicated, I can report this to the development team.
Thanks,
Meenakshi
