Gridview Data Loading Problem in ASP.Net

Sharad Gupta

11y1.2k.NET

I want to load data in gridview (at least 500000 records) without use paging, if any way to load data in gridview in fastest way without paging please tell me.

Thanks and regards

Sharad Gupta

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael11y ago
i'm not sure why you want to show 500000 records in a single page. This seems very bad design. Other than that it will seriously impact the performance also. AFAIK, there is no other way than (move the paging to procedure) this to improve the performance. So i suggest, if you have problem with procedure then try to fix it. Try to create execution plan for that query in procedure so that you can know where the procedure takes long time, in turn you can do performance tuneing in that query.
Sharad Gupta11y ago
Dear Dipankar Biswas

We have some issue in procedure , we can't change procedure, that's why i am not able to do that with procedure(Paging). Have you any idea without procedure(paging).
Dipankar Biswas11y ago
Hi...

A datagrid is limited by available system memory, and you're likely running into that. Assuming a process address space of, say, 1.5GB, that's about 4KB per datagrid row, if you had nothing else consuming memory in your process. 4KB is not unreasonable, assuming a dozen or so wide columns.

You're trying to display too many rows at once. I have to assume it's a pretty bad user experience too, trying to navigate through that many rows.
look at..https://msdn.microsoft.com/en-us/library/5aw1xfh3.aspx

and see..This atth file.. performance of data binding..

Thanks and regards
Dipankar Biswas