Retriving Data from Remote server(from SQL) to client system?

Question

0.00/5 (No votes)

See more:

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

Posted 31-Oct-13 5:39am

Member 10372820

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-10-31T05:45:00

Solution 1

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.

Posted 31-Oct-13 5:45am

ZurdoDev

Comments

Member 10372820 31-Oct-13 11:48am

Is there any way so that i can Improve this Latnecy issue with network?? Will WCF or Web service help in fast dataretrival?

ZurdoDev 31-Oct-13 11:55am

No. In .Net you can use a DataReader but the problem is still that the data needs to transfer over the wire. If you want to improve the performance of your network you should talk with your network admins.

Do you know where the server is physically compared to where your computer is?

ZurdoDev 31-Oct-13 11:55am

It takes 1 second on server, how long does it take on your machine?

Member 10372820 31-Oct-13 11:56am

My server is in US and my machine is in INDIA.

Member 10372820 31-Oct-13 11:57am

It takes 23 seconds on my machine

Member 10372820 31-Oct-13 12:00pm

One more thing, I developed a Website which do the same Data retrival, When i ran the website at my system it executes within a second.?? I don't know why the data retrival takes alot of time in desktop application compared to Websites...?

ZurdoDev 31-Oct-13 12:03pm

Pointing to the same server? What's different about the code.

Member 10372820 31-Oct-13 12:06pm

Code is same!! Are you sure RyanDev that it is related to Network?? Do u have any Link which Proves this Latency issue lies with the network?? I need a evidance which i can show it to our network administrator.

Your help will be much appreciated... thanks.

ZurdoDev 31-Oct-13 12:11pm

Perhaps post your code then. The relevant parts at least.

Retriving Data from Remote server(from SQL) to client system?

1 solution

Solution 1

Add your solution here

Preview 0

Retriving Data from Remote server(from SQL) to client system?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us