On Wed, 6 May 2020 at 08:19, Johanna Botman <[email protected]> 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ 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
