I execute some simple queries on my own system's sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server's sql server express 2005, the queries execution time is about 3 seconds or more and I don't know why. both of the systems have the same OS (win 2003 server), but our server have 1Gig ram and my system have 2 Gig.
This difference in RAM can be the major reason for query response time?
Please help me in this case if you know the reason.
September 4, 2010 7:40 AM
September 15, 2010 6:27 PM