Query Speed - Linked SQL Tables

[bs0d]

I have a general question. Suppose you link SQL Server tables in an MS Access Database.

If you write a query from another application (like Excel) to the MS Access database, how much slower would that query be vs. the same query directly to the table(s) on the SQL Server?

 

[Joe4]

I think there are a lot of variables that will affect performance, such as complexity of the query, design of your database (indexes etc), size of data, resources available (computer processing speed, connection speed, etc). With all those variables, I don't think there is any "hard-and-fast" answer anyone can give you.

To see what the difference in time will be, probably the best thing to do is try it out yourself, and time each one and compare the results.

 

[bs0d]

Maybe this is turning into an Excel question, but how can you time a query in VBA or ADO to be able to do as you suggested? Thanks

 

[Joe4]

Maybe these will help:
VBA Express : Excel - Test procedure run time
optimization - How do you test running time of VBA code? - Stack Overflow

 

[bs0d]

I see, thanks for the links

 

[bs0d]

This seems like a more simple solution (your post, Joe4) than the links above.
Only catch is - the times are stored as String: http://www.mrexcel.com/forum/excel-...ual-basic-applications-macro.html#post3705499