This is a discussion on MS SQL Server 2000 / MS Access - ODBC connection question within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello all! I have such question to all of you. I have some tables linked from MS SQL Server ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| ||||
| 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 |