Posted by Ben on 10/27/07 02:49

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.

It is still very slow.


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99D55F472EB07Yazorman@127.0.0.1...
> Ben (pillars4@sbcglobal.net) writes:
>> Regarding the optimizer, is that an official information?
>
> I'd say it's general information that applies to about any database
> product
> on the market. Not that I know very much about the optimizer in, say,
> Oracle. But I saw a post the other day that discussed Teradata, and it was
> amazingly familiar.
>
>
>
> --
> 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

[Back to original message]