<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Hi Johanna,</p>
<p>Unfortunately I can't help you explain the gradual slow down
during a longer edit session.</p>
<p>But I do have experience with databases (not SQL Server but
PostgreSQL) in a network and my recommendation is to always have
QGIS in the same network than the database. Having the database in
the cloud and QGIS in the LAN of your organization with a slow
network link in between will result in bad performance due to
network latency. In the long run, I would try to either bring the
database to the same LAN within your organization to avoid network
latency, or alternatively run QGIS desktop in the same
network/cloud where your database is located. There are still
functions in QGIS where certain database operations are processed
one feature at a time and network latency makes this much worse.
The developers are though trying to eliminate such feature by
feature processing in favour of processing whole batches at once,
which improves the situation with slow network connections.</p>
<p>If, for some reason you need the same database in two different
locations, then I would introduce two database installations local
to the respective networks and use replication in between to keep
the data in sync. This reduces the network latency issues
significantly.<br>
</p>
<p>Andreas<br>
</p>
<div class="moz-cite-prefix">Am 05.05.20 um 08:51 schrieb Johanna
Botman:<br>
</div>
<blockquote type="cite"
cite="mid:9c043a68bcdd4b4aa3924b5c55304291@melton.vic.gov.au">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does anyone have any ideas, or strategies,
to troubleshoot?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span
style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="font-size:12.0pt;mso-fareast-language:EN-AU">Johanna
Botman<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU">Assets
/ GIS Officer – Melton City Council<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-AU">
</span><span style="mso-fareast-language:EN-AU"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br clear="all">
***********************************************************************************<br>
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.<br>
***********************************************************************************<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</body>
</html>