<div dir="auto"><div><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, May 5, 2020, 00:06 Johanna Botman <<a href="mailto:johannab@melton.vic.gov.au">johannab@melton.vic.gov.au</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-AU" link="#0563C1" vlink="#954F72">
<div class="m_225177643384497262WordSection1">
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I have a situation where there are three of us using QGIS v3.4 connecting to a Microsoft 2016 SQL Server to add and edit items to tables in the same database at the same time. And I’m growing old waiting for things to happen.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">When we were all in the office, we connected through the work network to the databases in the cloud and suffered some issues with delay that may be caused by internet speed. Now that we are all working from home, we have the added complexity
of connecting to our home Wi-Fi then a VPN to the office before we then go out to the cloud.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">But now the bottom line is that no more than one user at a time can edit the tables. Responses are painfully slow and by mid-afternoon, QGIS is completely unresponsive.</p></div></div></blockquote></div></div><div dir="auto"><br></div><div dir="auto"><div dir="auto" style="font-family:sans-serif">Johanna, I'm struggling to understand your configuration here.</div><div dir="auto" style="font-family:sans-serif"><br></div><div dir="auto" style="font-family:sans-serif">Are you working via some kind of remote desktop software? It sounds like it.</div><div dir="auto" style="font-family:sans-serif"><br></div><div dir="auto" style="font-family:sans-serif">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?</div><div dir="auto" style="font-family:sans-serif"><br></div><div dir="auto" style="font-family:sans-serif">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.</div><div dir="auto" style="font-family:sans-serif"><br></div><div dir="auto" style="font-family:sans-serif">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).</div><div dir="auto" style="font-family:sans-serif"><br></div><div dir="auto" style="font-family:sans-serif">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)?</div></div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-AU" link="#0563C1" vlink="#954F72"><div class="m_225177643384497262WordSection1"><p class="MsoNormal"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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.</p></div></div></blockquote></div></div><div dir="auto"><br></div><div dir="auto">I'd be inclined to blame the network first, since that's what it sounds like has changed.</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-AU" link="#0563C1" vlink="#954F72"><div class="m_225177643384497262WordSection1"><p class="MsoNormal">
<u></u><u></u></p>
<p class="MsoNormal"><u></u> </p></div></div></blockquote></div></div><div dir="auto">Chris</div><div dir="auto"></div></div>