[dba-SQLServer] Developer Edition v. LocalDB

[John Colby]

Yes Stuart, quite correct.  My IBM experience was hitting a SQL Server on a
network.

I would argue however that doing it all in sql server and pulling the
results in has an additional advantage.  You just never know when an app is
going to explode and "oops, I need to move to SQL Server. (over a
network)"

I can tell you that migrating this complex 10-20 level deep complex query
mess out of Access into SQL Server was a royal PITA.  Usually this kind of
mess is created by an amateur.  I am not an amateur. There is almost no
downside to just doing it in SQL Server.  So IMHO if the tables are already
in SQL Server then just do the rest in SQL Server.

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
>
>

-- 
John W. Colby
Colby Consulting