Hi,
I have a situation where there are three of us using QGIS v3.4 connecting to a
Microsoft 2016 SQL Server to add and edit items to tables in the same database
at the same time. And I'm growing old waiting for things to happen.
When we were all in the office, we connected through the work network to the
databases in the cloud and suffered some issues with delay that may be caused
by internet speed. Now that we are all working from home, we have the added
complexity of connecting to our home Wi-Fi then a VPN to the office before we
then go out to the cloud.
But now the bottom line is that no more than one user at a time can edit the
tables. Responses are painfully slow and by mid-afternoon, QGIS is completely
unresponsive.
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.
Does anyone have any ideas, or strategies, to troubleshoot?
Johanna Botman
Assets / GIS Officer - Melton City Council
***********************************************************************************
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
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
