title: ASP.NET/Javascript: Loading huge data in browser
body: <p>I have this GUI that shows, let's say Customer Orders. When my client nailed down the requirements, he asked me to keep pagination like this,</p>
  
  <blockquote>
    <p><strong>Show Items Per Page : 10/50/150</strong></p>
  </blockquote>
  
  <p>For each customer there could be thousands of orders and each order will have atleast 50 attributes to show up in the screen. So, assume a 50 column html table with 2000 or 3000 records associated with it spanning across multiple database tables (anyway, this is a different story)</p>
  
  <p>Things were breeze until yesterday, now my client has come up with new change requests, in that he specified Show Items like this,</p>
  
  <blockquote>
    <p><strong>Show Items Per Page : 10/50/150/<em>All</em></strong></p>
  </blockquote>
  
  <p>Yes, he wanted to see 2000 or 3000 records by just select "All" option. Internally, this is not a big change, I would go back and remove the filters I apply on rowcount etc., but when it is loaded in GUI it really sucks ... view state was huge etc., etc.,</p>
  
  <p>I know, this is a standard problem. How you guys deal with it? I cannot convince my client to remove this "All" option, he got stick to it. (the reason is simple, he got a big 42" screen where he can easily see 1000 items in one page)</p>
  
  <p>I also tried to use javacript to prepare DOM in a ajax call .. but still, inserting 2000 TDs is really slow.</p>
  
  <p>Any help is greatly appreciated.</p>
  
  <p><strong>Some Extra Info</strong></p>
  
  <ol>
  <li>This application is a intranet application or else accessed through VPN connection</li>
  </ol>