[dba-SQLServer] Developer Edition v. LocalDB

[Arthur Fuller]

Thanks to all for your advice.

On Thu, Mar 31, 2022 at 9:35 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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! :-)
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>

-- 
Arthur