Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...DNN Platform (o...DNN Platform (o...Displaying Large Amount of Data in a DataGridDisplaying Large Amount of Data in a DataGrid
Previous
 
Next
New Post
1/27/2009 7:25 PM
 

In one of our web apps that was originally built on the .NET 1.1 framework, using C#, we have a DataGrid control.  (We are currently using .NET 3.5 framework.)  There are 11 columns in the control, one being a checkbox and the others containing data that is typically not more than 11 characters per column.  Under normal circumstances, our application populates this DataGrid with rows of data, the user can use the checkbox to select rows from the grid and then perform calculations later on. 

 
The issue that I’m running into is that when the DataGrid contains a lot of data (around 24,000 rows) we start seeing weird things happen on the page.  We’ve seen partial HTML tags (for example “<td align =”) displaying on the screen before and also within the DataGrid (we’ve seen “</” appear in a cell of the grid).  When this happens, any controls after/below the DataGrid do no display at all.  To make it even stranger, when this happens if the page is left open for a minute or two the DataGrid entirely disappears.  A few minutes later, additional controls on the page reset as if the page was loaded from scratch.
 
So my initial thoughts on the issue are that this is simply too much data to display in a DataGrid control.  I suspect that the large amount of data stored in v13wstat3 is at the heart of the issue.  Likely, implementing paging on the control and possibly using the .NET 3.5 GridView control will reduce the amount of data displayed and stored in v13wstat3 and resolve the issue.  However, I’m hitting a few speed bumps. 
 
First, the DataGrid will never load correctly in our production environment, but will usually load fine in our test environments.  We have the same amount of data that’s being displayed, so why would it matter which environment the app is running on?  By the way, our server set ups are the same and they’re patched to the same levels. 
 
Second, like I said the test usually works ok in our test environment.  Sometimes it has the same issue.  I’ve seen a correlation as to the number of users currently hitting the application at one time.  If two people load the DataGrid at the exact same time in our test environment, then it usually doesn’t display correctly, though not always.  I’ve also tried loading the DataGrid in production when no users were present (verified through IIS logs) and it still did not work.
 
Finally, like I said I have several ways that I believe will solve the issue, I still need the exact cause.  Our clients are asking for an exact cause of the issue before we start developing or implementing any code fixes.  So far all I can say is that I’ve got some good ideas of why the issue is occurring, but I don’t have any hard facts to give them (especially since it works in the test environment most of the time).  Do you guys have any thoughts or links that might help me out?  Just to give you one more piece of data, if I view the HTML source of the page once it’s loaded successfully, I copied the v13wstat3 section (in the hidden input _EVENTVALIDATION tag) and pasted it into a separate .txt file.  The file is 8.88MB, which I assume means I have almost 9MB in v13wstat3.
 
New Post
2/1/2009 9:00 PM
 

You seriopusly have to get paging on that grid and then see if you have any issues.  9MB for a page is ridiculous :)


Philip Beadle - Employee
 
New Post
2/2/2009 1:30 AM
 

Yes, you need to implement paging on the server-side. You should only ever be returning 10 records or so at a time.


Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
Previous
 
Next
HomeHomeDevelopment and...Development and...DNN Platform (o...DNN Platform (o...Displaying Large Amount of Data in a DataGridDisplaying Large Amount of Data in a DataGrid


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out