Click here to Skip to main content
11,932,681 members (61,623 online)
Rate this:
Please Sign up or sign in to vote.
I have a local and remote server and I’m executing same query on both but it takes a lot longer to execute on the remote server.

I’ve checked the query plans and they are same on both servers
Posted 10-May-13 18:51pm
Maciej Los 11-May-13 4:25am
And the question is...
Raja Soosai 11-May-13 7:00am
You want to improve your query performance?
arunrv 11-May-13 7:51am
May be server is having more data than your local system so it is taking a long time

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

There are way too many things that could be the issue. Try troubleshooting these and see if problem is there:
Are running on a slow connection?
Is it a server in your local network?
Are there any other heavy queries being run on the server?
Try pinging the sever and see what are response times.
Is remote server busy?

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151126.1 | Last Updated 12 May 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100