Out Of Memory Exception when adding 3lakh rows in ASP DataGrid

Question

In my web application i want to show a table data in Data Grid for that i am using Entity Framework 4.0 while executing i am getting exception that out of memory.

Is there any limitation in ASP.NET Data Grid. I am using Oracle DataBase.

Below is my code

        Entities obj = new Entities();
        GridView1.DataSource = obj.EQUIPMENTs.ToList();
        //Here i am getting exception
        GridView1.DataBind();

Do you really need the .ToList()?

Matthew Watson
– Matthew Watson

2013-04-09 07:32:08 +00:00
Commented Apr 9, 2013 at 7:32 — Matthew Watson
– Matthew Watson, Commented Apr 9, 2013 at 7:32
But still i am getting OutOfMemoryException

Jagadesh
– Jagadesh

2013-04-09 07:39:15 +00:00
Commented Apr 9, 2013 at 7:39 — Jagadesh
– Jagadesh, Commented Apr 9, 2013 at 7:39

Tigran · Accepted Answer · 2013-04-09 07:33:38Z

2

You have to check your memory consumption. Use a ProcessExplorer for easy check. If you are in limits, chech the amount of data you load into the collection.

Remember that CLR apart of the allocated RAM limitation has a limitation on LIst<T> size, I see obj.EQUIPMENTs.ToList(). For List<T>, limitation is 2GB (even on x64).

If one of these is true (or both), the solution is rearchitect your code.

Example:

It's hardly possible that your user need all that amount of data at once, may be you can slice it between different pages/tabs/whatever...

If you need some statistical information, some aggregation, or some calculation, do it on server and transfer only the results.

answered Apr 9, 2013 at 7:33

Tigran

62.3k8 gold badges90 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

weismat Over a year ago

If you are on 4.5 with 64bit, then you can increase the list size with <gcAllowVeryLargeObjects>.

Jagadesh Over a year ago

But for Windows DataGridView it is hardly taking 2 min to dispaly all the records

Tigran Over a year ago

@weismat: yes, but it's better do not do that. In 90% cases, there is other solution.

Tigran Over a year ago

@Jagadesh: I have no any information about state of your apllicaiton. That's why I suggest you first check out memory and colleciton size you get, which can be and usually is a source of such kind of problems.

Collectives™ on Stack Overflow

Out Of Memory Exception when adding 3lakh rows in ASP DataGrid

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related