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

[Johanna Botman]

Hi Nyall,

I've had good support ideas from you before so I knew that I untick all plugins before I asked for more assistance. Sadly, it has not made any difference. Did you mean to uninstall them all? I could try that.

And, to clarify, each user has their own machine, their own installation of QGIS and their own version of the Project file all pointing at the one database with all the tables. It does look like a network or database issue as I thought.

Thank you.



Johanna Botman

Assets / GIS Officer – Melton City Council

    

-----Original Message-----
From: Nyall Dawson [mailto:nyall.dawson at gmail.com] 
Sent: Wednesday, 6 May 2020 2:25 PM
To: Johanna Botman <johannab at melton.vic.gov.au>
Cc: chris hermansen <clhermansen at gmail.com>; qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+

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

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