SQL Server的速度提升？ [英] Speed Improvements With SQL Server?

问题描述

我有一个Access应用程序（拆分为FE和BE）运行了几年，

现在也用于第二个办公室，由WAN连接。

这个办公室存在网络问题，因为它被过度使用（对于一个IT人员来说，97％根据
！）。


我'我正在考虑将MDB应用程序转换为带有SQL Server的ADP

后端。为了证明所涉及的费用是合理的，我正试图感受

可能合理预期的改进。


经过大量搜索，我发现有很多网站都说它

会（或应该）更快，但我还没有找到任何提及

任何人这样做，以及他们是否真的能够获得速度

改进。


是否有任何实际的个人经验来自升级来自Access

他们可以共享的ADP + SQL Server吗？或者指向任何

网址？


MTIA

I have an Access app (split into FE and BE) running for some years,
that is now also being used in a second office, connected by a WAN.
This office has network problems, as it''s over-utilized (97% according
to one IT guy!!).

I''m looking into converting the MDB app into an ADP with a SQL Server
backend. To justify the costs involved, I''m trying to get a feel for
what spped improvements might reasonably be expected.

After a lot of searching, I''ve found a great many sites that say it
will (or should) be faster, but I have yet to find any mention of
anyone doing it, and whether they were actually able to get speed
improvements.

Has any had some actual personal experience in ''upsizing'' from Access
to ADP + SQL Server that they could share pls? Or point me to any
URLs?

MTIA

推荐答案

I我是为数不多的ADP支持者之一，他们定期向这个

新闻组发帖。


我已经将多个应用程序转换为ADP。我认为他们没有比本地MDB解决方案更快地运行
。我认为它们更少

安全。

如果您的应用程序需要复杂的选择，它们可以更快。

可以在服务器上更有效地实现-Database。


IMO，转到ADP（或通过ODBC实现
MDBS）和可能​​来自任何地方的SQL Server都没有速度优势接近由合格的，有经验的

Access Developer重写现有应用程序的
。开发人员占任何数据库应用程序的效率的95％。


8月8日上午10：09 * am，maxhugen< maxhu .. 。@ gmail.comwrote：

I am one of the few proponents of ADPs who posts regularly to this
newsgroup.

I''ve converted several applications to ADPs. I don''t think they run
noticeably faster than a local MDB solution. I think they are less
secure.
They can be faster if your application requires complex Selects which
MAY be effected more efficiently on a Server-Database.

IMO, there is no speed advantage to be gained by going to ADPs (or
MDBS via ODBC) and SQL Server that could come anywhere close to a
rewriting of an existing application by a qualified, experienced
Access Developer. The Developer accounts for 95% of the efficiency of
any Database application.

On Aug 8, 10:09*am, maxhugen <[e-mail]:

我有一个Access应用程序（拆分为FE和BE）运行了几年，

现在是也被用在第二个办公室，通过广域网连接。

这个办公室有网络问题，因为它被过度使用（97％根据一个IT的b
）那个!!）。


我正在考虑将MDB应用程序转换为带有SQL Server的ADP

后端。为了证明所涉及的费用是合理的，我正试图感受

可能合理预期的改进。


经过大量搜索，我发现有很多网站都说它好了b / b
会（或应该）*更快，但我还没有找到任何提及

的人，以及他们是否真的能够获得速度

改进。


是否有任何实际的个人经验来自升级来自Access
他们可以共享的ADP + SQL Server
？或者指向任何

网址？


MTIA

I have an Access app (split into FE and BE) running for some years,
that is now also being used in a second office, connected by a WAN.
This office has network problems, as it''s over-utilized (97% according
to one IT guy!!).

I''m looking into converting the MDB app into an ADP with a SQL Server
backend. To justify the costs involved, I''m trying to get a feel for
what spped improvements might reasonably be expected.

After a lot of searching, I''ve found a great many sites that say it
will (or should) *be faster, but I have yet to find any mention of
anyone doing it, and whether they were actually able to get speed
improvements.

Has any had some actual personal experience in ''upsizing'' from Access
to ADP + SQL Server that they could share pls? Or point me to any
URLs?

MTIA

Access应用程序通过广域网拆分通常几乎无法使用。

如果您遇到这种情况，那么无论多么重载

或者远程局域网是什么，它无论如何，它会像三条腿一样运行

只是因为Access架构固有的局限性。


但是，如果背面 - 最终是SQL Server，该应用程序通常可以在WAN上使用。明显比局域网慢，但仍然可以使用
。


所以，你可以期待的是从绝望中提高性能。 相当充足 - 根据任何指标，这可能是几个订单的改进

的数量！

" maxhugen" < ma ****** @ gmail.com在留言中写道

新闻：65 ************************ ********** @ j7g2000p rm.googlegroups.com ...

An Access application split over a WAN would normally be virtually unusable.
If this is what you are experiencing then it doesn''t matter how overloaded
or not the remote LAN is, it''s gonna run like a three-legged dog anyway
simply because of the limitations inherent in the architecture of Access.

However, if the back-end were SQL Server, the application would usually be
quite usable over a WAN. Noticeably slower than on a LAN, but nonetheless
usable.

So, what you can expect is to improve performance from "hopeless" to "quite
adequate" - which by any metric is probably an improvement of several orders
of magnitude!
"maxhugen" <ma******@gmail.comwrote in message
news:65**********************************@j7g2000p rm.googlegroups.com...

>我有一个Access应用程序（拆分为FE和BE）运行了几年，

现在也被用在第二个办公室，由WAN连接。

这个办公室有网络问题，因为它超过了 - 利用（97％根据

给一个IT人员！）。


我正在考虑将MDB应用程序转换为带有SQL Server的ADP

后端。为了证明所涉及的费用是合理的，我正试图感受

可能合理预期的改进。


经过大量搜索，我发现有很多网站都说它

会（或应该）更快，但我还没有找到任何提及

任何人这样做，以及他们是否真的能够获得速度

改进。


是否有任何实际的个人经验来自升级来自Access

他们可以共享的ADP + SQL Server吗？或者指向任何

网址？


MTIA

>I have an Access app (split into FE and BE) running for some years,
that is now also being used in a second office, connected by a WAN.
This office has network problems, as it''s over-utilized (97% according
to one IT guy!!).

I''m looking into converting the MDB app into an ADP with a SQL Server
backend. To justify the costs involved, I''m trying to get a feel for
what spped improvements might reasonably be expected.

After a lot of searching, I''ve found a great many sites that say it
will (or should) be faster, but I have yet to find any mention of
anyone doing it, and whether they were actually able to get speed
improvements.

Has any had some actual personal experience in ''upsizing'' from Access
to ADP + SQL Server that they could share pls? Or point me to any
URLs?

MTIA

啊，但WAN，Lyle，WAN ...


" lyle fairfield" < ly ************ @ gmail.com写信息

新闻：a9 ****************** **************** @ 12g2000h sd.googlegroups.com ...

我是为数不多的ADP支持者之一/>
新闻组。


我已将多个应用程序转换为ADP。我认为他们没有比本地MDB解决方案更快地运行
。我认为它们更少

安全。

如果您的应用程序需要复杂的选择，它们可以更快。

可以在服务器上更有效地实现-Database。


IMO，转到ADP（或通过ODBC实现
MDBS）和可能​​来自任何地方的SQL Server都没有速度优势接近由合格的，有经验的

Access Developer重写现有应用程序的
。开发人员占任何数据库应用程序的效率的百分之95.

Ah, but the WAN, Lyle, the WAN...

"lyle fairfield" <ly************@gmail.comwrote in message
news:a9**********************************@12g2000h sd.googlegroups.com...
I am one of the few proponents of ADPs who posts regularly to this
newsgroup.

I''ve converted several applications to ADPs. I don''t think they run
noticeably faster than a local MDB solution. I think they are less
secure.
They can be faster if your application requires complex Selects which
MAY be effected more efficiently on a Server-Database.

IMO, there is no speed advantage to be gained by going to ADPs (or
MDBS via ODBC) and SQL Server that could come anywhere close to a
rewriting of an existing application by a qualified, experienced
Access Developer. The Developer accounts for 95% of the efficiency of
any Database application.

这篇关于SQL Server的速度提升？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！