I am just trying to fetch top 5 records from sql server 2008 in the production server and it is fetching the data in 1 second. when i try to execute the same quer from the remote machine it is taking 1 minute 53 seconds. the data size is 200 KB and i am using 3 MbPS line. i had tested the same from different high speed networks but the response time is same (Very Slow). How can i improve the response time.
Thanks in Advance.