By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Datareader or Dataset ?

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
.

Jul 19 '05 #2

P: n/a
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

Jul 19 '05 #3

P: n/a
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

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.