[dba-SQLServer] Developer Edition v. LocalDB

[Stuart McLachlan]

I'd expect very similar results with normal  recordsets  and queries on tables when 
comparing  ODBC to SQL Server  and  Access ACE backends regardless of where the BE 
is/

However try those activities over a LAN compared to pass through queries, using SQL 
Server views or SPs and you will get very different results.

When working over a network, JC is dead right when he says:
"There are huge performance benefits to allowing sql server perform all the
queries, joins etc. It can be an order of magnitude faster."

-- 
Stuart

On 31 Mar 2022 at 23:44, Daniel Waters wrote:

> I put an application together as described for one customer with SQL.
> The scenario was a local area network with ODBC table links, not a
> WAN, and using DAO - not ADO.  Speed was quite fast. At one time, I
> did a thorough test to compare speed between SQL with ODBC table links
> vs. Access tables (BE) and Access table links (FE). The results showed
> almost identical speed.
> 
> But on a WAN I could see a problem! :-)
>