问：缓慢更新 [英] Q: Slow update
问题描述
大家好
我希望你能原谅我在这里发帖（我也发布到ado网站
但没有在解决方案之后我很紧急。
有人可以帮帮我吗？我正在更新数据库上的表格，即我已经修改了数据集中的表格，并且我想将它更新到
表格中的SQL数据库最初来自。我正在使用数据适配器和更新命令
它的工作原理但是它太慢了！有人可以告诉我任何
技术加速吗？
提前谢谢
Geoff
Hi All
I hope you''ll forgive me for posting this here (I''ve also posted to ado site
but with no response so far) as I''m urgently after a solution.
Can anybody help me? I''m updating a table on a database i.e. I''ve modified
the table in a DataSet and I want to update it to the SQL database which the
table originally came from. I''m using a data adaptor and the update command
and it works BUT it is soooooooooo slow!!! Can anybody tell me of any
techniques to speed it up?
Thanks in advance
Geoff
推荐答案
Hi Cor
啊是的！这本来不会有帮助 - 大笑
不幸的是，我似乎无法访问你建议的新闻组
即它确实如此没有出现在搜索上。
Geoff
" Cor Ligthert [MVP]" <无************ @ planet.nl>在消息中写道
news：ue ************** @ TK2MSFTNGP14.phx.gbl ...
Hi Cor
Ah yes! It would have helped wouldn''t it - lol
Unfortunately, I don''t seem to be able to access your suggested newsgroup
i.e. it does not turn up on a search.
Geoff
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:ue**************@TK2MSFTNGP14.phx.gbl...
Geoff，
我可以想象你在ADO新闻组中没有得到关于这个AdoNet问题的答案。
:-)
然而试试吧在ADONET新闻组中。
microsoft.public.dotnet.framework.adonet
如果你想要这个因为真的需要
一些代码而不是交叉看看你能做些什么来帮助你。
我希望这会有所帮助
Cor
Geoff,
I can imaging that you did not get an answer on this AdoNet question in
the ADO newsgroup.
:-)
However try it in the ADONET newsgroup.
microsoft.public.dotnet.framework.adonet
and than crossposted if you want to this one because there is real needed
some code to see what you do to be able to help you.
I hope this helps something
Cor
您要更新多少条记录？每行多少数据？它更新整个表格或仅更改了你改变的行吗？你和SQL数据库之间的连接速度是多少？
" Geoff Jones" <无******** @ email.com>在消息中写道
news：43 ********************** @ news.dial.pipex.com。 ..
How many records are you updating? How much data per row? Is it updating
the entire table or just the rows you changed? What is the connection speed
between you and the SQL database?
"Geoff Jones" <no********@email.com> wrote in message
news:43**********************@news.dial.pipex.com. ..
大家好
我希望你能原谅我在这里发帖（我也发布到ado
网站但没有回复到目前为止，在解决问题之后我很紧急。
任何人都可以帮助我吗？我正在更新数据库上的表，即我已经修改了DataSet中的表，我想将它更新到最初来自的表的SQL数据库。我正在使用数据适配器和更新
命令
它的工作原理但是它太快了！任何人都可以告诉我任何加速它的技术吗？
提前致谢
Geoff
Hi All
I hope you''ll forgive me for posting this here (I''ve also posted to ado
site but with no response so far) as I''m urgently after a solution.
Can anybody help me? I''m updating a table on a database i.e. I''ve modified
the table in a DataSet and I want to update it to the SQL database which
the
table originally came from. I''m using a data adaptor and the update
command
and it works BUT it is soooooooooo slow!!! Can anybody tell me of any
techniques to speed it up?
Thanks in advance
Geoff
Geoff Jones写道：
Geoff Jones wrote:
大家好
我希望你能原谅我在这里发帖（我也发布到了ado网站<但是到目前为止还没有回应）因为在解决方案之后我很紧急。
任何人都可以帮助我吗？我正在更新数据库上的表，即我已经修改了DataSet中的表，我想将它更新到最初来自的表的SQL数据库。我正在使用数据适配器和更新命令
它的工作原理但它太慢了！谁能告诉我任何加速它的技术？
提前致谢
Geoff
Hi All
I hope you''ll forgive me for posting this here (I''ve also posted to ado site
but with no response so far) as I''m urgently after a solution.
Can anybody help me? I''m updating a table on a database i.e. I''ve modified
the table in a DataSet and I want to update it to the SQL database which the
table originally came from. I''m using a data adaptor and the update command
and it works BUT it is soooooooooo slow!!! Can anybody tell me of any
techniques to speed it up?
Thanks in advance
Geoff
这将有助于理解你在做什么以及你如何做b
- 是你在局域网/拨号/本地机器上工作？
- 用于插入的更新语句是什么。
- 表中有多少条记录
- 你在表中有哪些索引。
Chris
It would help to have an understanding to what you are doing and how you
are doing it....
- Are you working over a lan/dialup/local machine?
- What is the update statement you are using to do the insert.
- How many records are in the table
- What indexes do you have in the table.
Chris
这篇关于问：缓慢更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
