Datareader or Dataset ?

[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

[guy]

how does an operator physically read a million rows from a
web page?

guy

-----Original Message-----
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 mypage. 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
.

[Bob Lehmann]

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
"srinivas" <sr******@yahoo.com> wrote in message
news:04****************************@phx.gbl...

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

[Wim Hollebrandse]

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

"srinivas" <sr******@yahoo.com> wrote in message
news:04****************************@phx.gbl...

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