ASP.NET/Javascript: Loading huge data in browser
<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>
