On Wed, 6 May 2020 at 16:33, Johanna Botman <johan...@melton.vic.gov.au> wrote: > > Hi Nyall, > > Yes, I have restarted QGIS. I have even restarted the laptop. > BTW I am using QGIS 3.4 as are my colleagues. We are trying to get our IT > folk to upgrade us to 3.10 but are not having any luck with that.
In that case it's almost certainly NOT a QGIS issue. I would test direct modification of the database through another utility (such as the SQL server management console) to confirm that the slowness is a database issue. Nyall > > > > Johanna Botman > > Assets / GIS Officer – Melton City Council > > > > > -----Original Message----- > From: Nyall Dawson [mailto:nyall.daw...@gmail.com] > Sent: Wednesday, 6 May 2020 4:31 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 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. > > ********************************************************************** > > ************* > > *********************************************************************************** > 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