Search:   Namespaces Discussions .NET v1.1 Feedback

Error loading large data into a daragrid Messages   Related Types This message was discovered on microsoft.public.dotnet.framework.aspnet. Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions. Post a new message to this list... Manju (VIP) Hi, Am developing an ASP.Net application using c#. At one point I need to bind a dataset to my DataGrid and display to the user. When the numbers of rows are less there is no problem in binding the datagrid. But when the number of rows is a large number I tested for 56K rows. The DataBind() line generates an error and the aspnet_wp.exe restarts itself automatically. An application event log is created as : aspnet_wp.exe (PID: 3336) was recycled because memory consumption exceeded the 301 MB (60 percent of available RAM). I have implemented paging PageSize 500. The test server is a 512MB RAM, 2.39GHz, 15GB Hard disk machine. Is the error because of the test server configuration or is there a limit in the number of rows that can be bound to a datagrid. Any help is appreciated.. Reply to this message...        Hermit Dave no the worker process was recycled because when you touched the dataset and it was sufficiently heavy (by frameworks standard - based on your machine spec). it think its 60% of available memory usage (or something like that). try increasing virtual memory though i would suggest just add a whole loads of RAM sticks.. I prefer 1GB+ RAM on my dev / server pcs.the more the better. if you are contrained and cant add RAM then consider a way to limit the records being sent.. ie use some funky database side paging. -- Regards, Hermit Dave (http://hdave.blogspot.com) "Manju" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...        Karl As the error states, ASP.Net's worker process recycled itself because you exceeded the 60% limit. You can change this limit by going to: C:\WINNT\Microsoft.NET\Framework\v1.1.4322\CONFIG (windows on XP and you might have a different version) and editing the machine.config file. Look for <processModel which has a memoryLimit set to "60" However, do note that putting this higher (even to 100) is a poor bandaid. If three users hit the site at the same time, they'll cause the same thing to happen. I believe in IIS 6.0 you have a more refined control over this (physical and virtual memory limits) This thread might be of some use: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=wo6rPnt5DHA.2768%40cpmsftngxa07.phx.gbl&rnum=1&prev=/groups%3Fq%3Dasp.net%2Brecycling%2BmemoryLimit%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3Dwo6rPnt5DHA.2768%2540cpmsftngxa07.phx.gbl%26rnum%3D1 Karl -- MY ASP.Net tutorials http://www.openmymind.net/ "Manju" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message...        Manju (VIP) Thanks a lot Hermit and Dave, I shall increase my server RAM and proceed ahead. "Karl" wrote: [Original message clipped] Reply to this message...        Hermit Dave lol.. its either Hermit or Dave or both...but exclues the AND.. i think you meant KARL -- Regards, Hermit Dave (http://hdave.blogspot.com) "Manju" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... > Thanks a lot Hermit and Dave, I shall increase my server RAM and proceed ahead. [Original message clipped] Reply to this message...        Manju (VIP) Oops am so sorry I meant Dave and Karl... :) "Hermit Dave" wrote: [Original message clipped] Reply to this message...     System.Web.UI.WebControls.DataGrid System.Windows.Forms.DataGrid Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com