填充大型列表视图的进程使用问题 [英] process usage problem with filling a large list view

问题描述

这里有问题，我在数据表人员中有一个大约9,000到20,000

人的数据集...我正在将其读入列表

一次一行地查看一个...将每个人添加到列表视图中，好吧

这可以很好地工作到大约1000人然后它开始'到'得到真正的表现

让人们进入（大量的处理时间用完了）......有没有人知道

我可以做的任何优化，使这个过程工作更快？

感谢

解决方案

SQL Server工具中的查询分析器似乎能够加载90,000人

记录没有任何问题...任何想法它如何运作如此之快？

我可以用列表视图实现

Brian Henry < brianiup [NOSPAM] @ adelphia.net>在留言中写道

news：ur ************** @ TK2MSFTNGP12.phx.gbl ...

这里有问题，我在数据表人员中有一个大约9,000到20,000人的数据集......然后我逐行将它读入一个
列表视图中。 ..将每个人添加到列表视图中，好吧
这可以很好地工作到大约1000人然后它开始'真的
显示让人们进入（大量的处理时间用完） ...有没有人知道我可以做的任何优化
，以使这个过程更快地工作？
感谢

"然后我逐一将它读入一个列表视图中一行一行


Listview控件支持绑定，这意味着你应该能够

只是数据绑定并称之为一天。为什么一个一个地添加它？


检查出来：
http://msdn.microsoft.com/library/de...et08262002.asp


-

Elliot M. Rodriguez，MCSD


我的.Net博客，附带提示：
http://derivedclass.europe.webmatrixhosting.net


" Brian Henry" < brianiup [NOSPAM] @ adelphia.net>在消息中写道

news：em ************** @ TK2MSFTNGP11.phx.gbl ...

SQL Server中的查询分析器工具似乎能够装载90,000人的记录而没有任何问题......任何想法它如何运作如此之快？
，我可以使用列表视图实现

Brian Henry < brianiup [NOSPAM] @ adelphia.net>在消息中写道
新闻：ur ************** @ TK2MSFTNGP12.phx.gbl ...

这里有问题，我有一个在数据表人员中有大约9,000到20,000人的数据集......然后我将其读入列表

逐行查看一个。 ..将每个人添加到列表视图中，
这可以很好地工作到大约1000人然后它开始'真的

show

put （很多处理时间用完了）...有没有人

知道

我可以做的任何优化这个过程的工作速度要快得多吗？
感谢

我做过那篇文章一次，它的数据量仍然非常非常慢......我真正想要的是一个优化的版本，用于

大（超过10， 000行数据..基本上MSDN上的那个例子是

也逐行添加项目....


''加载所有子字段

For Field = 1 to mColumns.Count - 1

Item.SubItems.Add（GetField（InnerSource.Item（Row），_

mColumns（ Field）.Field）.ToString）

下一页

Items.Add（Item）

这就是我现在用的那个我设计


" Elliot M. Rodriguez" < noemail>在消息中写道

news：％2 **************** @ tk2msftngp13.phx.gbl ...

"然后我逐行将它读入一个列表视图中一行一行

Listview控件支持绑定，这意味着你应该能够对它进行数据绑定并将其命名为天。为什么要逐一添加呢？

检查一下：
http://msdn.microsoft.com/library/de...et08262002.asp
-
Elliot M. Rodriguez，MCSD

我的.Net博客，附带提示：
http://derivedclass.europe.webmatrixhosting.net

Brian Henry < brianiup [NOSPAM] @ adelphia.net>在消息中写道
新闻：em ************** @ TK2MSFTNGP11.phx.gbl ...

SQL Server工具中的查询分析器似乎是能够加载90,000
人

记录没有任何问题......任何想法它如何运作如此之快？

我可以用列表视图实现

" Brian Henry" < brianiup [NOSPAM] @ adelphia.net>在消息中写道
新闻：ur ************** @ TK2MSFTNGP12.phx.gbl ...

这里有问题，我有一个在数据表人员中有大约9,000到20,000人的数据集...我正在将其读入

列表

视图一个一个一个一行...将每个人添加到列表视图中，

这样可以很好地工作到大约1000个人然后它开始'真的要

show

让人们进入（大量的处理时间用完）...有没有人

知道

的post_quotes>我可以做的任何优化，以使这个过程更快地工作
？谢谢

Well here is the problem, I have a data set with about 9,000 to 20,000
people in it in the data table "people"... I am then reading it into a list
view one at a time row by row... adding each person to the list view, well
this works fine up to about 1,000 people then it start''s to get really show
putting the people in (a lot of process time used up)... does anyone know of
any optimizations i could do to make this processess work a lot faster?
thanks

解决方案

Query analyzer in SQL Server tools seems to be able to load 90,000 people
records with out any problems at all... any idea how it works so fast? that
i could implement with a listview
"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

Well here is the problem, I have a data set with about 9,000 to 20,000
people in it in the data table "people"... I am then reading it into a list view one at a time row by row... adding each person to the list view, well
this works fine up to about 1,000 people then it start''s to get really show putting the people in (a lot of process time used up)... does anyone know of any optimizations i could do to make this processess work a lot faster?
thanks

" I am then reading it into a list view one at a time row by row"

The Listview control supports binding, which means you should be able to
just databind to it and call it a day. Why add to it one by one?

Check this out:
http://msdn.microsoft.com/library/de...et08262002.asp

--
Elliot M. Rodriguez, MCSD

My .Net blog, with tips here and there:
http://derivedclass.europe.webmatrixhosting.net

"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:em**************@TK2MSFTNGP11.phx.gbl...

Query analyzer in SQL Server tools seems to be able to load 90,000 people
records with out any problems at all... any idea how it works so fast? that i could implement with a listview
"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

Well here is the problem, I have a data set with about 9,000 to 20,000
people in it in the data table "people"... I am then reading it into a list

view one at a time row by row... adding each person to the list view, well this works fine up to about 1,000 people then it start''s to get really

show

putting the people in (a lot of process time used up)... does anyone

know of

any optimizations i could do to make this processess work a lot faster?
thanks

I did that article already once, it is still very very slow with large
amounts of data... what I''m really looking for is an optimized version for
large (over 10,000 rows) of data.. essentially that example on MSDN is
adding items row by row also....

'' load all subfields
For Field = 1 To mColumns.Count - 1
Item.SubItems.Add(GetField(InnerSource.Item(Row), _
mColumns(Field).Field).ToString)
Next
Items.Add(Item)
which is how mine is right now with the one I designed

"Elliot M. Rodriguez" <noemail> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

" I am then reading it into a list view one at a time row by row"

The Listview control supports binding, which means you should be able to
just databind to it and call it a day. Why add to it one by one?

Check this out:
http://msdn.microsoft.com/library/de...et08262002.asp
--
Elliot M. Rodriguez, MCSD

My .Net blog, with tips here and there:
http://derivedclass.europe.webmatrixhosting.net

"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:em**************@TK2MSFTNGP11.phx.gbl...

Query analyzer in SQL Server tools seems to be able to load 90,000 people

records with out any problems at all... any idea how it works so fast?

that

i could implement with a listview
"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

Well here is the problem, I have a data set with about 9,000 to 20,000
people in it in the data table "people"... I am then reading it into a

list

view one at a time row by row... adding each person to the list view,

well this works fine up to about 1,000 people then it start''s to get really

show

putting the people in (a lot of process time used up)... does anyone

know

of

any optimizations i could do to make this processess work a lot faster? thanks

这篇关于填充大型列表视图的进程使用问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！