Datareader or Dataset ?

  • Thread starter Thread starter srinivas
  • Start date Start date
S

srinivas

I have a table with 1 million rows. I want to DISPLAY all
the rows in ASP.NET page. If 10,000 users are accessing my
page. I need to go for Datareader or Dataset...Problem is,
if i use Datareader there will be 10,000 connections to
the database. If i use Dataset it occupies 10,000 memory
blocks(xml format data) in my web server....Don't want
caching concept...If some one help me in this area?

Thanks in advance....
Srinivas
 
Besides the fact that no human can use 1 million rows of data......

If each row contained only 1 byte of data, and you had no html(table) your
page would be 1 MB. Now add
<tr><td></td><td></td><td></td></tr> * 1million. Even with out the data
that's 36MB.

Good Luck!

Bob Lehmann
 
You want to show 1 million rows in one ASP.NET page? Hmmm. I don't think
that would make a lot of sense from and end user perspective - imagine to
have to browse through 1 million rows...

Paging might be a better solution in this scenario.

Regards,
Wim Hollebrandse
http://www.wimdows.com
http://www.wimdows.net
 
Back
Top