Posted by Erland Sommarskog on 10/27/07 08:50

Ben (pillars4@sbcglobal.net) writes:
> By the way, I noticed one thing:
>
> If I run the MS Access in the server computer itself, the slow
> performance issues are not visible. But then again the hardware has two
> Intel Quad-Core Xeon processors, 10GB of RAM, and 15,000RPM SATA hard
> drives. I just wanted to point it out here maybe it tells something. I
> am still leaning towards network connection problem or ODBC
> configuration.

If the operation is running decently fast if you have the client on
the server machine, then it does not seem that the problem is with the
query execution.

As for ODBC configuration, check that ODBC tracing is not enabled.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: CASE count wierd join needed maybe? just one more field needed!
• Prev in forum: Re: Slow Execution Performance
• Thread view: Re: Slow Execution Performance

[Reply to this message]