ASP.NET freezes for large recordsets

  • Thread starter Thread starter mick b
  • Start date Start date
M

mick b

Hi,

My application populates a datagrid that can contain up to 10000 result
rows. The datagrid successfully populates and displays in the browser
window.

When I push a button to either navigate away from the page or clear the
datagrid the page freezes and the browser indicates that it is not
responding requiring me to restart the application.

Has anybody had similar issues with ASP.NET. Am I trying to display to
much data in a single html page resulting in memory issues for the
browser?

Any help appreciated

Mick
 
This is definitely too much data in a web page. How it loads this is a
miracle of modern science in and of itself. But you will definitely hang
when you try to poste again because this data must now roundtrip to the
server. cpu will be pegged for a while trying to service the request which
is why it is unresponsive. At this point, your iis worker process is
probably going to be hosed because of the amount of memory needed to service
this request. The memory will not be given back to the OS (because of a bug
in the framework) so it will bring down the server even if it succeeds. This
has been my hard experience.

Try to filter the data so you are returning a couple hundred rows at most. A
user cannot possibly comprehend anything more than this anyway. The concept
of programming on the web is not to create applications that streams large
amounts of data at a time, but rather moving several small chunks of data
over a period of time. If you keep this in mind, your application will
benefit.

regards
 
Back
Top