[AccessD] Table vs View Recordsource

[Gustav Brock]

Hi Anita

No, it is not the bandwidth, it's the latency of the cheap instances. 
Fetching data is relatively fast, so is running queries, but saving data is slow, which means that normal operation of a bound form can be slow as well.

The upside of this is, however, that using Azure SQL is an extremely efficient way to locate bottlenecks. An inefficient query _will_ run slow, so modifying it to run fast will make it scream if run off a normal (in-house) SQL Server.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af Anita Smith
Sendt: 25. juni 2021 05:31
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Table vs View Recordsource

The 5 minutes I did spend setting up a database on Azure and connecting to it, seemed to be too slow so I binned it. I guess it's a matter of bandwidth.