问题描述
我正在开发一个作为SQL数据库前端的应用程序。
虽然这不是一个直接要求，但应用程序可能需要
为了能够在以后通过互联网连接，所以我们通过远程实现数据连接
。通过HTTP通道和二进制格式化器实现远程处理
。然而，我们已经注意到，远程调用似乎比OLEDB调用的要慢得多，所以我给b $ b写了一个独立的测试应用程序并进行了检查。在测试应用程序中，OLEDB调用
平均在5秒内获得11583条记录，而获取相同数据需要47秒的远程处理。 OLEDB和远程处理都是用完全相同的参数调用完全相同的存储过程。
任何人都可以告诉我为什么远程处理这么慢，以及我如何能够更快地实现
？
TIA
Ron L.
I am working on an application that is a front-end for a SQL database.
While it is not an immediate requirement, the application will probably be
required to be able to connect via the internet at a later date, so we are
implementing the data connections via remoting. The remoting is implemented
via the HTTP channel, with the binary formatter. We have noticed, however,
that the remoting calls seemed to be much slower that the OLEDB calls, so I
wrote a standalone test app and checked. In the test app, the OLEDB calls
get 11583 records in 5 seconds on average, while it takes the remoting over
47 seconds to get the same data. Both the OLEDB and the remoting are
calling the exact same stored procedure with the exact same parameters.
Can anyone tell me why the remoting is so much slower, and how I can make it
faster?
TIA
Ron L.
推荐答案
这篇关于远程调用比OLEDB调用慢很多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！