ASP表可以显示200列，50万行？ [英] can ASP table display 200 columns, 500,000 rows?
问题描述
我确定显示200列和
500,000行数据听起来有点疯狂。但是我已经将数据从一个
的Lotus Notes数据库中提取到Sql Server一段时间了，但是
Lotus Notes开始破解，专栏获得
已损坏。无法处理数据量和
列的数量。 Sql Server没有问题。但显示
数据是最重要的。最终用户希望能够将页面滚动到他们选择的列中，或者是
能够向上或向下滚动。我打算把表格分成
，但这需要额外的
点击进入表格的下一部分。
在asp中使用200列表是否可行？或者
我应该坚持这个部分的想法吗？我必须告诉我
dept。他们从Lotus Notes开始，但是
无法查询数据。我一直建议将
完全迁移到Sql Server / IIS。注释可以
至少显示所有列。建议赞赏。
谢谢，
Rich
我'' d说这只是个人偏好的问题，因为考虑到了这个大的响应并且在服务器上增加了额外的压力
的缺点。当你想要一杯水时，你是否需要填一杯并带上
，然后带回沙发，或者你拿起整条河来试试
到把它拉回你的沙发？
雷在工作
Rich <一个******* @ discussions.microsoft.com>在消息中写道
news：cf **************************** @ phx.gbl ... < blockquote class =post_quotes>我确定显示200列和500,000行数据听起来有点疯狂。但是我已经将数据从一个Lotus Notes数据库中提取到Sql Server一段时间了，但是Lotus Notes开始崩溃，列被破坏了。无法处理数据量和
列数。 Sql Server没有问题。但显示
数据是最重要的。最终用户希望能够将页面滚动到他们选择的列，或者能够向上或向下滚动。我正在考虑将表格拆分为部分，但这需要额外点击以进入表格的下一部分。在asp中使用200列表是否可行？或者我应该坚持这个部分的想法吗？我必须告诉我的部门。他们从Lotus Notes开始，但无法查询数据。我一直建议将项目完全迁移到Sql Server / IIS。注释可以至少显示所有列。建议表示赞赏。
谢谢，
Rich
Rich写道：我'确定显示200列和500,000行数据听起来有点疯狂。但是我已经将数据从一个Lotus Notes数据库中提取到Sql Server一段时间了，但是Lotus Notes开始崩溃，列被破坏了。无法处理数据量和
列数。 Sql Server没有问题。但显示
数据是最重要的。最终用户希望能够将页面滚动到他们选择的列，或者能够向上或向下滚动。我正在考虑将表格拆分为部分，但这需要额外点击以进入表格的下一部分。在asp中使用200列表是否可行？或者我应该坚持这个部分的想法吗？我必须告诉我的部门。他们从Lotus Notes开始，但无法查询数据。我一直建议将项目完全迁移到Sql Server / IIS。注释可以至少显示所有列。建议表示赞赏。
谢谢，
Rich
我喜欢section部分理念。用户无论如何都要点击某些内容来滚动。
滚动。如果他们点击滚动条或按钮会有什么区别？
你可以通过给他们一个列名下拉列表来卖掉它 -
当他们选择时一，它会显示相应的部分
我会非常谨慎地尝试将500,000行流向客户端
一举这有点荒谬，你不觉得吗？屏幕上有多少行在任何时候对任何人都有用？
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。
" Rich" <一个******* @ discussions.microsoft.com>在消息中写道
news：cf **************************** @ phx.gbl ... < blockquote class =post_quotes>我确定显示200列和500,000行数据听起来有点疯狂。
You Betcha !!
只需考虑显示它所需的HTML：
"< table>"，再加上
500,000批< tr>
200多个< td>和< / td>在其中，再加上
500,000手< / tr>加上最终的
"< / table>"
即'：
7 + 500,000 *（4 + 200 *（4 + 5）+ 5）+ 8字节
= 904,500,015字节
~ = 0.83千兆字节!!
且没有*任何*实际数据!!
传输时间:(不计算/构建/在服务器上）
100Mbit以太网72秒
56Kbit调制解调器：只是害羞了36个小时。
不在我们在雷德蒙德联盟的朋友中 - 不到七岁
*天*为/单档/下载Visual Studio 2003 - 但是
到达那里...... ;-)
问候，
Phill W.
和是;我非常熟悉拨号下载时间... :-(
I''m sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can''t handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down. I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn''t query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns. Suggestions appreciated.
Thanks,
Rich
I''d say it''s just a matter of personal preference after considering the
drawbacks of having that large or a response and putting that extra strain
on the server. When you want a drink of water, do you fill a glass and take
that with you back to your sofa, or do you pick up the entire river and try
to lug that back to your sofa?
Ray at work
"Rich" <an*******@discussions.microsoft.com> wrote in message
news:cf****************************@phx.gbl...I''m sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can''t handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down. I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn''t query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns. Suggestions appreciated.
Thanks,
Rich
Rich wrote:I''m sure it sounds kinda nutty to display 200 columns and
500,000 rows of data. But I have been pulling data from a
Lotus Notes database into Sql Server for a while now, but
Lotus Notes is starting to crack, columns getting
corrupted. Can''t handle the volume of data and number of
columns. Sql Server has no problem. But displaying the
data is the big deal. The end users want to be able to
scroll acros a page to the colum of their choice, or be
able to scroll up or down. I was thinking of breaking up
the table into section, but this would reqire additional
clicking to get to the next section of the table. Would
it be feasable to have a 200 column table in asp? or
should I stick with the section idea? I have to tell my
dept something. They started out with Lotus Notes but
couldn''t query the data. I have been suggesting to
migrate the project entirely to Sql Server/IIS. Notes can
at least display all the columns. Suggestions appreciated.
Thanks,
Rich
I like the "section" idea. The user would have to click something anyways to
do the scroll. What difference if they click a scrollbar or a button?
You might be able to sell it by giving them a dropdown of column names -
when they select one, it will display the appropriate "section"
I would be very leary of trying to stream 500,000 rows to a the client in
one fell swoop.It''s kind of ridiculous, don''t you think? How is having that
many rows on the screen at one time of any use to anyone?
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.
"Rich" <an*******@discussions.microsoft.com> wrote in message
news:cf****************************@phx.gbl...I''m sure it sounds kinda nutty to display 200 columns and
500,000 rows of data.
You Betcha!!
Just consider the HTML needed to display it:
"<table>", plus
500,000 lots of "<tr>" with
200 lots of "<td>" and "</td>" within that, plus
500,000 lots of "</tr>", plus the final
"</table>"
that''s:
7 + 500,000 * ( 4 + 200 * ( 4 + 5 ) + 5 ) + 8 bytes
= 904,500,015 bytes
~= 0.83 Gigabytes!!
and that''s without *any* actual data in it!!
Transmission time: (not counting /building/ it on the server)
100Mbit ethernet 72 seconds
56Kbit modem: just shy of 36 hours.
Not quite in Our Friends in Redmond''s league - just under seven
*days* for the /single-file/ download of Visual Studio 2003 - but
getting there... ;-)
Regards,
Phill W.
and yes; I''m /very/ familiar with dial-up download times... :-(
这篇关于ASP表可以显示200列，50万行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
