Hey Johanna We have a similar setup and QGIS has been running okay to my knowledge though it is slower than being in the office. One option you could ask your IT dept to setup a virtual machine (Citrix etc) with QGIS installed. This would place your machine within your network and keep all your data transactions low latency. I have been running QGIS and FME from our enterprise application servers to achieve the same effect while working from home.
Luke On Wed, May 6, 2020 at 4:37 PM Nyall Dawson <[email protected]> wrote: > On Wed, 6 May 2020 at 16:33, Johanna Botman <[email protected]> > 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:[email protected]] > > Sent: Wednesday, 6 May 2020 4:31 PM > > To: Johanna Botman <[email protected]> > > Cc: chris hermansen <[email protected]>; [email protected] > > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+ > > > > On Wed, 6 May 2020 at 16:05, Johanna Botman <[email protected]> > 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:[email protected]] > > > Sent: Wednesday, 6 May 2020 2:34 PM > > > To: Johanna Botman <[email protected]> > > > Cc: chris hermansen <[email protected]>; [email protected] > > > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+ > > > > > > On Wed, 6 May 2020 at 14:31, Johanna Botman < > [email protected]> 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:[email protected]] > > > > Sent: Wednesday, 6 May 2020 2:25 PM > > > > To: Johanna Botman <[email protected]> > > > > Cc: chris hermansen <[email protected]>; > > > > [email protected] > > > > Subject: Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+ > > > > > > > > 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 > > > > > > > > ******************************************************************** > > > > ** > > > > ************* 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user -- *Luke Bassett* * <[email protected]>*Melbourne Australia
_______________________________________________ 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
