从远程服务器（从SQL）到客户端系统的数据？ [英] Retriving Data from Remote server(from SQL) to client system?

问题描述

大家好，



我有一个连接到服务器上的SQL服务器的应用程序。



当我从我的系统运行应用程序时，需要花费大量时间来检索数据，但是当我在服务器上运行相同的应用程序时，它会在一秒内运行。



有没有什么方法可以让需要花费大量时间在我的系统上运行的查询花费更少的时间。



问候，

Sagar

解决方案

如果它是相同的查询，那么你的缓慢是由于网络延迟。您的网络可能存在一些问题，但更有可能是您的计算机需要更长的时间。旅行的数据要远得多。



在查询本身中你无法做任何事情，以使你的机器与服务器上的速度更快。

Hi All,

I have a application which connects to SQL server which is at server.

It takes a lot of time to retrive data when i ran the application from my system,but when i ran the same application at server it runs with in one second.

Is there any way so that the Query which takes lot of time to run at my system takes less time.

Regards,
Sagar

解决方案

If it's the same query then your slowness is due to network latency. It's possible that your network has some issues but it's more likely that it just takes longer from your machine. The data has much farther to travel.

There is not anything you can do in the query itself to make it faster on your machine vs. on the sever.

这篇关于从远程服务器（从SQL）到客户端系统的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！