MS SQL Server 2000 / MS Access - ODBC connection question

MS SQL Server 2000 / MS Access - ODBC connection question

Post by Kamy » Fri, 22 Apr 2005 01:09:37


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.
 
 
 

MS SQL Server 2000 / MS Access - ODBC connection question

Post by Simon Haye » Fri, 22 Apr 2005 18:50:16

No idea - it depends how big the tables are, what your queries look
like, how you execute your queries etc. If you're using stored
procedures, for example, then I would expect MSSQL to be faster, as all
the processing happens on the server, and it can use indexes, caching
etc. The best way to get an answer is simply to test it yourself.

Simon