有更好，更快的方式吗？ [英] Is there a better, faster way?
问题描述
寻找关于使用Access进行编程的替代方案的一些意见。
我发现我经常需要遍历我的记录集（首先是
last）执行计算和想知道是否有更快的
替代品吗？
VB.Net和MS SQL怎么样 - 我可以用这个吗？ >
组合？会不会更快？
谢谢，
威廉
Looking for some opinions on alternatives to programming with Access.
I find that quite often I need to loop through my recordsets (first to
last) performing calculations and was wondering if there is a faster
alternative than Access?
What about VB.Net and MS SQL - could I do the same with this
combination? Would it be any faster?
Thanks,
willem
推荐答案
嗨Willem，
您应该使用更新查询而不是记录集。更新查询比用于更新表中的
字段的记录集更有效。
问候，
Barry
Willem < SW ****** @ hotmail.com>在消息新闻中写道：bv ******************************** @ 4ax.com ...
寻找关于使用Access进行编程的替代方案的一些意见。
我发现我经常需要遍历我的记录集（首先是
last）执行计算和想知道是否有更快的
替代品吗？
VB.Net和MS SQL怎么样 - 我可以用这个吗？ >
组合？它会更快吗？
谢谢，
威廉
Hi Willem,
You should be using an update query rather than a recordset. Update queries are much more efficient than recordsets for updating
fields in tables.
Regards,
Barry
"Willem" <sw******@hotmail.com> wrote in message news:bv********************************@4ax.com...
Looking for some opinions on alternatives to programming with Access.
I find that quite often I need to loop through my recordsets (first to
last) performing calculations and was wondering if there is a faster
alternative than Access?
What about VB.Net and MS SQL - could I do the same with this
combination? Would it be any faster?
Thanks,
willem
"威廉" < SW ****** @ hotmail.com>在消息中写道
news：bv ******************************** @ 4ax.com ...
"Willem" <sw******@hotmail.com> wrote in message
news:bv********************************@4ax.com...
寻找关于使用Access编程的替代方案的一些意见。
我发现我经常需要遍历我的记录集（首先是
最后）执行计算和想知道是否有比Access更快的替代方案？
VB.Net和MS SQL怎么样？我可以用这个
组合做同样的事情吗？它会更快吗？
Looking for some opinions on alternatives to programming with Access.
I find that quite often I need to loop through my recordsets (first to
last) performing calculations and was wondering if there is a faster
alternative than Access?
What about VB.Net and MS SQL - could I do the same with this
combination? Would it be any faster?
我不确定你的意思是更快的替代方案。你的意思是从
开发速度的角度来看..或者从数据库的实际速度来看
的观点？
例如，sql-server可以扩展到更多用户，然后是基于文件的mdb
文件。因此，您可以将前端保持为ms-access，并将后端
部分移动到sql server（您现在正在运行拆分数据库吗？）。
如果你在谈论没有网络的本地数据库，那么你将不会通过从ms-access转移到.net来看到性能有任何改善。
但是，如果您正在谈论涉及的互联网连接，那么
新工具可以提供很多帮助。这真的取决于你想要的是什么。
完成。
另一方面，你没有提到你工作的文件有多大
with。 100,000条记录的文件通常可以在不到两美元的时间内处理。在本地PC上，JET实际上可以读取磁盘上的记录比bql server（同样的pc..no网络）快b / b
。但是，sql server在格式不好的sql上做了更好的优化工作（事实上，它是多么令人惊讶，它可以做什么）。
但是，不要寻求软件更改来修复性能问题。大多数时候，只需更换工具就不能解决性能问题。
然而，在很多情况下，为正确的工作选择正确的马可以做出一个
真正的区别。
如果你需要在互联网上移动数据，或者需要良好的安全性，那么sql
服务器会产生很多感。另一方面，如果你的计算机上只有一些文件
...可能不需要sql server。
你的问题似乎有点开放这里。如果您要求进行其他开发
系统允许您获取记录并以某种
记录集处理它们？答案是肯定的......他们这样做。但是，那些其他系统是否允许你更快地宣称这些记录？那么，这取决于数据来自何处，以及您对数据的处理方式。
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
http://www.attcanada.net/~kallal.msn
It is not sure what you mean by "faster alternative". Do you mean from a
development speed point of view..or from a actual speed of the database
point of view?
For example, sql-server scales to many more users then a file based mdb
file. So, you can keep your front end as ms-access, and move the back end
part to sql server (are you running a split database now?).
If you are talking about a local database with no network, then you will not
see any improvement in performance by moving from ms-access to .net.
However, if you are talking about a internet connection being involved, then
the new tools can help a lot. It really depends on what you are trying to
accomplish.
On the other hand, you don''t mention how large the files you are working
with. Files of 100,000 records can usually be dealt with in less then a
second or two. On a local pc, JET actually can read records off the disk
faster then sql server (same pc..no network). However, sql server does a
better optimization job on poorly formed sql (in fact, it is amazing what it
can do).
However, don''t look to a software change to fix performance problems. Most
of the time, simply changing tools will NOT fix performance problems.
However, i many cases, choosing the right horse for the right job can make a
real difference.
If you need to move data across the internet, or need good security,then sql
server makes a lot of sense. On the other hand, if you just have some files
on your computer...sql server is likely not needed.
Your question seems a bit open here. If you are asking do other development
systems allow you to grab records and process them in some kind of
recordset? The answer is yes..they do. However, do those other systems let
you profess those records faster? Well, it depends on where the data is
coming from, and what you are doing with the data.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn
"杰科" < www.clearpointsystems.com@use_contact_form.com>写道：
"deko" <www.clearpointsystems.com@use_contact_form.com> wrote:
VB.Net和MS SQL怎么样？我可以用这个
组合做同样的事吗？它会更快吗？
What about VB.Net and MS SQL - could I do the same with this
combination? Would it be any faster?
很明显，答案是肯定的。但这是Access的一大跳。我最近已经从Access编程切换到.NET / SQL Server - 它就像是从单引擎水坑跳线转到F14 Tomcat。有更多的力量，但需要一些时间来学习驾驶......
Clearly, the answer is yes. But it''s a big jump from Access. I''ve recently
made the switch to .NET/SQL Server from Access programming - it''s like going
from a single-engine puddle jumper to a F14 Tomcat. There''s a lot more
power, but it takes some time to learn how to drive...
如何更多动力？好吧，SQL Server显然有存储过程和
等。但我对.NET方面更感兴趣。
Tony
-
Tony Toews ，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以阅读整个消息主题。
Microsoft Access Links，Hints ，提示&会计系统
http://www.granite.ab.ca /accsmstr.htm
这篇关于有更好，更快的方式吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
