ODBC connection - faster or slower in MS Access/MS SQL Server 2000

[Kamyk]

Hello all!

I have such question to all of you.
I have some tables linked from MS SQL Server 2000. Is time of processing
query
based on these linked tables from MS SQL Server 2000, faster or slower than
the time of processing the same query based on tables, which are not linked
but
imported to MS Access?

Can you answer this question?

Thank you in advance for posts
Marcin from Poland.

[Steve Jorgensen]

On Tue, 19 Apr 2005 17:23:48 +0200, "Kamyk" <ma************ **@poczta.onet. pl>
wrote:

Hello all!

I have such question to all of you.
I have some tables linked from MS SQL Server 2000. Is time of processing
query
based on these linked tables from MS SQL Server 2000, faster or slower than
the time of processing the same query based on tables, which are not linked
but
imported to MS Access?

Can you answer this question?

Thank you in advance for posts
Marcin from Poland.

That depends on a lot of things...

The most obvious thing it depends on is the size of the result set. In a
client/server arrangement, you want to keep result sizes down, and do
aggregation and filtering on the server.

Next, how many people will be sharing the back-end data. Access slows down as
soon as 2 people are sharing a JET back-end, but the server won't have this
limitation. On the other hand, if the server is too slow, or you're trying to
use MSDE with more users than it's optimized for, the server will be slow.

There are many other factors such as how fast is your LAN, how big are your
data sets, etc.