[Qgis-user] MS SQL Server, multi users and QGIS v3+

Wed May 6 05:41:01 PDT 2020

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 <nyall.dawson at gmail.com> wrote:

> On Wed, 6 May 2020 at 16:33, Johanna Botman <johannab at 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.dawson at gmail.com]
> > Sent: Wednesday, 6 May 2020 4:31 PM
> > To: Johanna Botman <johannab at melton.vic.gov.au>
> > Cc: chris hermansen <clhermansen at gmail.com>; qgis-user at 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 <johannab at 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.dawson at gmail.com]
> > > Sent: Wednesday, 6 May 2020 2:34 PM
> > > To: Johanna Botman <johannab at melton.vic.gov.au>
> > > Cc: chris hermansen <clhermansen at gmail.com>; qgis-user at 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 <
> johannab at 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.dawson at gmail.com]
> > > > Sent: Wednesday, 6 May 2020 2:25 PM
> > > > To: Johanna Botman <johannab at melton.vic.gov.au>
> > > > Cc: chris hermansen <clhermansen at gmail.com>;
> > > > qgis-user at 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 <
> johannab at 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 at 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 at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 

*Luke Bassett*
* <lukembassett at gmail.com>*Melbourne Australia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200506/4084076e/attachment-0001.html>