Re: Slow Execution Performance

Ben (pillars4@xxxxxxxxxxxxx) 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@xxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Linked server to ODBC DSN
    ... Server, and want to create a linked server to this same ODBC DSN: ... Provider = "Microsoft OLE DB Provider for ODBC Driver" ... Then i connect to the SQL Server using QA, and try to run my query (that ...
    (microsoft.public.sqlserver.server)
  • Re: DAO vs ADO
    ... > to re-write it at least a little but can I do it in DAO? ... > tables were on a SQL Server! ... ODBC, one table could be on the corporate server, and the other ODBC might ...
    (microsoft.public.access.conversion)
  • Re: error setting up ODBC for remote sqlexpress database
    ... We were able to get it to work with the ODBC native client driver. ... Server could be stopped in the client. ... is to install Management Studio for SQL Server 2005 Express ...
    (microsoft.public.sqlserver.odbc)
  • Re: Tools to remotely manage Access 2K
    ... No you can not use an ODBC connection over the net to a jet backend mdb ... the SQL server, and therefore you can't connect over a tc/ip connecton ... An ADP will not work in this case unless you are using SQL server (adp ONLY ... Note that before you grab a copy of this mdb file, ...
    (microsoft.public.access.gettingstarted)