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

[Johanna Botman]

Hi Chris,

Thanks for your reply.
I don’t have any transparency on the config of our network so I can’t answer that. It is possible that my frustration peaks in the afternoon and it is possible that is a red herring.

Each user has a similar project that contains tables in a SQL database. We need to add and edit items in these tables but struggle when more than one person is editing in the same table.

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.

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.
***********************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200505/bd35a5ff/attachment.html>