<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<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:12.0pt;
font-family:"Times New Roman",serif;}
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-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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]-->
</head>
<body lang="EN-AU" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi Sunil,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">We capture asset data for a local council. There are 27 tables in the database representing each asset category. We have times when
the demand for the import is higher eg at the end of the calendar year and at the end of the financial year. When it is busy, we can be adding 2-3000 assets per week. Some of the tables already contain 45 000+ assets.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">We have no alternatives to software. IT won’t allow it.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif;color:#1F497D">Johanna Botman<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Assets / GIS Officer – Melton City Council<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">
</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> se_sunil@rediffmail.com [mailto:se_sunil@rediffmail.com]
<br>
<b>Sent:</b> Wednesday, 6 May 2020 7:35 PM<br>
<b>To:</b> Johanna Botman <johannab@melton.vic.gov.au><br>
<b>Subject:</b> Re: [Qgis-user] MS SQL Server, multi users and QGIS v3+<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
Hi!<br>
<br>
<br>
Can you please share the purpose and process for that you are using QGIS and SQL Server (Multi user).
<br>
So that I can suggest you another alternate for the same purpose which is fast as well as easy to
<br>
operate for multi users.<br>
<br>
<br>
<br>
Thanks<br>
<br>
Sunil <br>
<br>
<br>
On Tue, 05 May 2020 12:35:42 +0530 Johanna Botman wrote<br>
><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Hi,<br>
<br>
I have a situation where there are three of us using QGIS v3.4 connecting to a Microsoft 2016 SQL
<br>
Server to add and edit items to tables in the same database at the same time. And I’m growing old
<br>
waiting for things to happen.<br>
<br>
When we were all in the office, we connected through the work network to the databases in the cloud and
<br>
suffered some issues with delay that may be caused by internet speed. Now that we are all working from
<br>
home, we have the added complexity<br>
of connecting to our home Wi-Fi then a VPN to the office before we then go out to the cloud.<br>
<br>
But now the bottom line is that no more than one user at a time can edit the tables. Responses are
<br>
painfully slow and by mid-afternoon, QGIS is completely unresponsive.<br>
<br>
Users love to blame the software. That’s what they are interacting with, but I don’t believe that it is
<br>
all QGIS’ problem. I’d prefer to blame a database that appears to not respond well to a multi user
<br>
environment.<br>
<br>
<br>
Does anyone have any ideas, or strategies, to troubleshoot?<br>
<br>
<br>
<br>
Johanna Botman<br>
<br>
Assets / GIS Officer – Melton City Council<br>
<br>
<br>
<br>
<br>
<br>
***********************************************************************************<br>
><br>
The information in this message is privileged and confidential, intended only for the use of the
<br>
individual or entity named above. If you are not the intended recipient you are hereby notified to
<br>
delete the message and that any dissemination, copying or use of its content is strictly prohibited. If
<br>
you have received this message in error please notify the Melton City Council.<br>
><br>
***********************************************************************************<br>
><br>
<br>
<br>
_______________________________________________<br>
<br>
Qgis-user mailing list<br>
<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p>
</div>
<br clear="both">
***********************************************************************************<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>
</body>
</html>