On Wed, 6 May 2020 at 16:05, Johanna Botman <johan...@melton.vic.gov.au> wrote: > > Just to confirm that I have been working all afternoon with all my plugins > uninstalled. This has made no difference to the issue.
Have you tried restarting QGIS when you hit this slowness issue? If so, do you experience the slowness immediately after restarting? Nyall > > > > Johanna Botman > > Assets / GIS Officer – Melton City Council > > > > -----Original Message----- > From: Nyall Dawson [mailto:nyall.daw...@gmail.com] > Sent: Wednesday, 6 May 2020 2:34 PM > To: Johanna Botman <johan...@melton.vic.gov.au> > Cc: chris hermansen <clherman...@gmail.com>; qgis-user@lists.osgeo.org > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+ > > On Wed, 6 May 2020 at 14:31, Johanna Botman <johan...@melton.vic.gov.au> > wrote: > > > > 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. > > Yes, there is a chance that a plugin which is disabled but still installed > **could** cause an issue (although unlikely). A clean profile would be the > easiest way to test this, and QGIS makes it easy to flick between profiles so > you can quickly switch back to your regular profile after testing. > > Nyall > > > > > 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.daw...@gmail.com] > > Sent: Wednesday, 6 May 2020 2:25 PM > > To: Johanna Botman <johan...@melton.vic.gov.au> > > Cc: chris hermansen <clherman...@gmail.com>; qgis-user@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 <johan...@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@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. > > ********************************************************************** > > ************* > > *********************************************************************************** > 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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
