[Qgis-user] MS SQL Server, multi users and QGIS v3+

[Nyall Dawson]

On Wed, 6 May 2020 at 08:19, Johanna Botman <johannab at melton.vic.gov.au> wrote:

> What I do know is that the refresh – or my ability to edit and save data - in the attribute table slows down when multiple users are editing the same table. And I know that this behaviour has become worse now that we are all working from home and have the added ‘hops’ in the network created by our home Wi-Fi and VPN.

Unless you do have multiple users sharing a single machine (e.g. via
remote desktop or similar), then this is almost certainly a database
or network issue*. If everyone is running distinct QGIS sessions on
different machines then it's highly unlikely that you'd also see the
same issues arise at the same time of day.

* Unless it's a plugin related issue. I'm aware of some plugins which
are badly written and cause gradual slow-downs over the course of a
single QGIS session. So possibly if you ALL had a bad plugin installed
and ALL started a fresh QGIS session at the start of the day then you
may experience simultaneous slow downs in the afternoon. The fix for
this would be starting a clean profile with no plugins installed and
testing.

Nyall



>
>
>
> Our workaround today will be to try to make sure that only one person is in a particular table at a time.
>
>
>
>
>
>
>
>
>
> Johanna, I'm struggling to understand your configuration here.
>
>
>
> Are you working via some kind of remote desktop software? It sounds like it.
>
>
>
> What is your theory as to why response time is worse in the afternoon? Is your connection to your office being overloaded? Is your office's connection to the cloud database also being overloaded? Do your IT support people have any thoughts on why response is worse in the afternoon?
>
>
>
> The reason I'm keying on this is that one possibility is that your network infrastructure is slightly insufficient for the morning load and completely insufficient for the afternoon load.
>
>
>
> On the contrary, if your database is starved of resources, why is it worse now than when you were working from the office? Again your IT people should be able to look at log info or otherwise instrument your server to find out if it's the problem (having suggested this I admit I wouldn't use SQL Server and know nothing about tuning it).
>
>
>
> Can you run a different configuration, say with QGIS on your home computer and some kind of database proxy in your office, or even a direct connection to the cloud database (assuming I've guessed your configuration correctly)?
>
>
>
> Users love to blame the software. That’s what they are interacting with, but I don’t believe that it is all QGIS’ problem. I’d prefer to blame a database that appears to not respond well to a multi user environment.
>
>
>
> I'd be inclined to blame the network first, since that's what it sounds like has changed.
>
>
>
> Chris
>
>
> ***********************************************************************************
> The information in this message is privileged and confidential, intended only for the use of the individual or entity named above. If you are not the intended recipient you are hereby notified to delete the message and that any dissemination, copying or use of its content is strictly prohibited. If you have received this message in error please notify the Melton City Council.
> ***********************************************************************************
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user