This is a migrated thread and some comments may be shown as answers.

Binding 100K records with 300 columns to GridView gives out of MemoryException

3 Answers 152 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Chirag
Top achievements
Rank 1
Chirag asked on 15 Sep 2010, 03:46 PM
We are trying to bind 100K records with 300 columns to GridView. First time the Data is loaded fine. For the second time we get the out of MemoryException. I am Binding the grid with dataset. Please advise.

Any help is appreciated!!!

3 Answers, 1 is accepted

Sort by
0
Jack
Telerik team
answered on 20 Sep 2010, 05:16 PM
Hi Chirag,

Thank you for contacting us.

Could you share which version exactly are you using (your account shows no downloads, which to give us a hint).

We tested RadGridView in similar scenario by using a DataTable containing 300 columns and 100000 rows. The occupied memory is about 200 Mb. Could you please send me your application in order to investigate this case further? You can do this in a new support ticket.

A bit off topic, please ask the person who has purchased our controls in your company to add you as a License Developer to the purchase. This will give you full access to the products your company has purchased, to our downloads section, and to our support ticketing system. Additionally, all your questions will be reviewed according to the license you have. More information on License Developers you can find here: www.telerik.com/account/faqs.aspx.

Sincerely yours, Jack
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Chirag
Top achievements
Rank 1
answered on 20 Sep 2010, 06:57 PM
thanks  for your feedback....we were able to achive the same with some fine tuning of the code but what if we need to exceed 100k records to say 200K with same number of columns...what could be the limit...
0
Jack
Telerik team
answered on 23 Sep 2010, 10:15 AM
Hello Chirag,

The limit is the available memory. 200K rows will occupy 400 Mb. We plan to implement data virtualization feature in one of our upcoming releases. This feature will be in use when handling millions of records and will enable generating endless data on the fly. We will appreciate it if you share with us your scenario. This will allow us to shape our new feature better.

I am looking forward to your reply. 

Regards,
Jack
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
GridView
Asked by
Chirag
Top achievements
Rank 1
Answers by
Jack
Telerik team
Chirag
Top achievements
Rank 1
Share this question
or