<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:x="urn:schemas-microsoft-com:office:excel" 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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Franklin Gothic Book";
panose-1:2 11 5 3 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML - förformaterad Char";
margin:0cm;
font-size:10.0pt;
font-family:"Courier New";}
span.HTML-frformateradChar
{mso-style-name:"HTML - förformaterad Char";
mso-style-priority:99;
mso-style-link:"HTML - förformaterad";
font-family:Consolas;
mso-fareast-language:SV;}
span.E-postmall23
{mso-style-type:personal-reply;
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:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1066418421;
mso-list-template-ids:1888533324;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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="SV" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><a name="T_Default_Reply"><span style="mso-fareast-language:EN-US">Hi!<o:p></o:p></span></a></p>
<p class="MsoNormal"><span style="mso-bookmark:T_Default_Reply"><span lang="EN-GB" style="mso-fareast-language:EN-US">If just storing and reading is the scope and not editing, maybe another file format would be suitable. Like
</span></span><a href="https://flatgeobuf.org/"><span style="mso-bookmark:T_Default_Reply"><span lang="EN-GB" style="mso-fareast-language:EN-US">https://flatgeobuf.org/</span></span><span style="mso-bookmark:T_Default_Reply"></span></a><span style="mso-bookmark:T_Default_Reply"><span lang="EN-GB" style="mso-fareast-language:EN-US">.
Not tested by me but could be a good alternative.<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:T_Default_Reply"><span lang="EN-GB" style="mso-fareast-language:EN-US"><o:p> </o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:T_Default_Reply"><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:black">Karl-Magnus Jönsson</span></b></span><span style="mso-bookmark:T_Default_Reply"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book",sans-serif;color:black"><o:p></o:p></span></span></p>
<span style="mso-bookmark:T_Default_Reply"></span>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Från:</b> QGIS-User <qgis-user-bounces@lists.osgeo.org> <b>
För </b>Árni Geirsson via QGIS-User<br>
<b>Skickat:</b> den 16 mars 2023 15:08<br>
<b>Till:</b> Sadowski Jarosław <jaroslaw.sadowski@cpk.pl><br>
<b>Kopia:</b> qgis-user@lists.osgeo.org<br>
<b>Ämne:</b> Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">I do appreciate the good advice to use DBMS, I am doing that too and understand the advantages. I would never consider using a geopackage if I thought that multiple people would want to edit them at the same time. But that is not the case
and that is not my problem. Sometimes, I just want to keep geodata in a file on a network share and run the risk (in my case insignificant) that the file will be corrupted by multi user access. This I can do with shapefiles, but unlike the shapefiles, I have
to set the read-only flag on the geopackages stored on the network to get decent rendering speed, without ever wanting to edit the files. I think wanting to use file based storage for geodata in a networked environment is not unreasonable, even if there is
some danger of corruption. All file based formats are probably subject to that risk, but I repeat, that issue is not what I am talking about, just the rendering speed of data in a geopackage that is not set to read-only.<o:p></o:p></p>
<div>
<p class="MsoNormal">I suspect that there is no solution and that I will just have to live with this - as I have done for years. It is just a bit annoying. And I am surprised how little it is discussed.<br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span style="color:black">Árni </span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, 16 Mar 2023 at 13:46, Sadowski Jarosław via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">+1<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Don’t use file formats to edit by multiple users. I was occurring some critical problems, as for example disappearing objects from database or LOOOOONG read for
first time </span><span lang="EN-US" style="font-family:"Segoe UI Emoji",sans-serif">☹</span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Use PostgreSQL or other solutions like:</span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"><a href="https://merginmaps.com/" target="_blank"><span lang="EN-US">Mergin Maps: Collect, Store and Analyze your Geo-Data Easily</span></a><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"><a href="https://gis--support-pl.translate.goog/gis-box/?_x_tr_sl=pl&_x_tr_tl=en&_x_tr_hl=pl&_x_tr_pto=wapp" target="_blank"><span lang="EN-US">GIS Support » GIS.Box
(gis--support-pl.translate.goog)</span></a><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="PL"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="790" style="width:592.5pt">
<tbody>
<tr>
<td width="790" valign="top" style="width:592.5pt;padding:0cm 0cm 11.25pt 0cm">
<p><strong><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#3D3C3F">_________________________________</span></strong><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3D3C3F"><o:p></o:p></span></p>
<p><strong><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:#102B4D">Jarosław Sadowski</span></strong><span style="font-size:9.0pt;color:#102B4D"><br>
Kierownik Zespołu ds. Ochrony Środowiska | <em><span style="font-family:"Calibri",sans-serif">Biuro Strategii i Planowania, Projektowania i Inżynierii Podprogramu Kolejowego</span></em></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#102B4D"><br>
</span><em><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#102B4D">Environmental Protection Team Leader | Railway Subprogramme Strategy & Planning, Design & Engineering Department</span></em><span style="font-size:9.0pt;color:#102B4D"><br>
e: <a href="mailto:jaroslaw.sadowski@cpk.pl" target="_blank"><span style="color:#102B4D">jaroslaw.sadowski@cpk.pl</span></a><br>
m: +48 532 720 230</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#102B4D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> QGIS-User <<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>>
<b>On Behalf Of </b>Bo Victor Thomsen via QGIS-User<br>
<b>Sent:</b> Thursday, March 16, 2023 2:35 PM<br>
<b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only</span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt" id="m_-1341851179974007423footer">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#FFEB9C">
<span lang="PL" style="color:black">UWAGA: Ta wiadomość pochodzi spoza CPK Sp. z o.o. Proszę pomóż zadbać o bezpieczeństwo naszej organizacji. Zastanów się, zanim otworzysz link lub załącznik.</span><span lang="PL"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span lang="PL"> <o:p></o:p></span></p>
<div>
<p><span lang="PL">When any user on your network access the geopackage layer and (maybe unnecessarily) puts the layer in edit mode, there will be created 2 extra files in the same directory as the gpkg file resides in. And QGIS behaves different regarding
<i>both</i> read and write operations when these file are present. This is probably the explanation of the longer reading times, even if nobody actually is editing the layer. When the user stops the editing mode for the layer, the 2 files disappear.<o:p></o:p></span></p>
<p><span lang="PL">You can check if this is the explanation:<o:p></o:p></span></p>
<ol start="1" type="1">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span lang="PL">Open the gpkg layer in read mode on one computer, check the access speed of the same layer on
<i>another</i> computer. <o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span lang="PL">Set the layer in edit mode on the first computer, check the access speed to the layer on the second computer<o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span lang="PL">Revert the edit mode on the first computer, check the access speed to the layer on the second computer.<o:p></o:p></span></li></ol>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">I am guessing, that situations 1 and 3 are fast, while situation 2 is slow.
<o:p></o:p></span></p>
<p><span lang="PL">First of all: Never, ever try to implement some kind of multi-user editing on a file based format, where the file resides on a networked drive. It will never, ever work reliably. At some point 2 users will try to edit the same layer at the
same time and it will go kaboom (I can read from your mails that you are aware about this). This goes for - probably - every file based format on a network drive.
<o:p></o:p></span></p>
<p><span lang="PL">Secondly: What about making the gpkg file read-only at the network share level for most of the users. And only granting write access to the gpkg file for certain users that are instructed in
<i>not</i> setting the layer in edit mode unless it's strictly necessary ? <o:p></o:p></span></p>
<p><span lang="PL">The best solution: Install Postgres/PostGIS on your NAS <o:p>
</o:p></span></p>
<pre><span lang="PL">Med venlig hilsen / Best regards<o:p></o:p></span></pre>
<pre><span lang="PL"> <o:p></o:p></span></pre>
<pre><span lang="PL">Bo Victor Thomsen<o:p></o:p></span></pre>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Den 16-03-2023 kl. 13:49 skrev Árni Geirsson via QGIS-User:<o:p></o:p></span></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Thank you for the various responses.
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Let me be clear that what I am griping about is not the locking aspect that would allow multiple users to edit without conflict. I fully understand that the geopackage
is not safe for that, nor is the shapefile and perhaps also the file geodatabase. In my case, the likelihood of two people wanting to edit the same geopackage is negligible, so I take my chances. My only gripe is the rendering speed of larger geopackages on
a shared network, if they are not set specifically to read-only. That is not a problem with the shapefile and I think probably not with a file geodatabase. I am a long time user of geopackages in a networked environment and I will continue to use them - they
are great - there is just this problem of rendering speed over a network.<br clear="all">
<o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL" style="color:black">Árni </span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">On Thu, 16 Mar 2023 at 12:33, Sebastian Gutwein <<a href="mailto:bas@rdgland.com" target="_blank">bas@rdgland.com</a>> wrote:<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">This is all beyond my expertise but I have also struggled with the effective use of gpkg’s. In my case over google drive. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Here is what SQLite (the underlying software for gpkgs) says about using a SQLite database on a network:
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sqlite.org%2Fuseovernet.html&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gF5jBExKrp2Hlks%2FQEHefiiG0FJFhqAG8fJ0VxBs4Kc%3D&reserved=0" target="_blank">https://www.sqlite.org/useovernet.html</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">I hope that someday someone implements a system that allows this to work efficiently as gpkgs are better in many respects than shapefiles. Perhaps Geodiff could
be part of that solution. <o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMerginMaps%2Fgeodiff&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bcngOeZeGv1iT%2BEEOV2Vtf3%2FZRXxYLBvgRuX0SMFOdI%3D&reserved=0" target="_blank">https://github.com/MerginMaps/geodiff</a><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">On Thu, Mar 16, 2023 at 8:04 AM Árni Geirsson via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>> wrote:<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Hi Jorge
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">I understand what you are pointing at and I use databases such as Postgres/PostGIS also with good results. The thing is that working with data in files sometimes
has advantages and that is certainly how shapefiles have been used. The geopackage has been suggested as a replacement for the shapefile in the context of regular QGIS usage without any caveat saying that geopackages only replace the storage and transfer role
of shapefiles and that geopackages should not be used for editing in a shared environment, as is perfectly possible with shapefiles and widely practiced. Not all users have access to database systems such as Postgres. I'm just looking for some clarity on best
practices for the common scenario of working with QGIS using file based data in a network environment.<br clear="all">
<o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL" style="color:black">Árni</span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">On Thu, 16 Mar 2023 at 11:47, Jorge Gustavo Rocha via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>> wrote:<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p><span lang="PL">Hi,<o:p></o:p></span></p>
<p><span lang="PL">For data storage and manipulation databases are suitable. Files are not.
<o:p></o:p></span></p>
<p><span lang="PL">Geopackages are wonderful to transfer data between systems or to archive an entire project (snapshot of data, styles and the project itself).<o:p></o:p></span></p>
<p><span lang="PL">Regards,<o:p></o:p></span></p>
<p><span lang="PL">Jorge<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">On 16/03/23 11:30, Árni Geirsson via QGIS-User wrote:<o:p></o:p></span></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Thank you Jarosław. Isn't it strange that this was discussed 5 years ago and SMB file sharing is very common? Would a linux based NAS be able to use another protocol?
What are my options for file based data sharing in QGIS? Abandoning geopackages is not a realistic option for me, but I could get a different kind of NAS unit, if that helps, what kind then? What amazes me is how little I see this discussed. There was a message
in this thread this morning from Thomas Struller, but I am not sure it is about the same root problem, maybe Thomas can elaborate.
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Should this perhaps be discussed in another forum, closer to the development of geopackage/sqlite?<br clear="all">
<o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL" style="color:black">Árni Geirsson</span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">On Thu, 16 Mar 2023 at 09:52, Sadowski Jarosław <<a href="mailto:jaroslaw.sadowski@cpk.pl" target="_blank">jaroslaw.sadowski@cpk.pl</a>> wrote:<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Long story short: gpkg is bad idea for network drives as SMB/NAS etc</span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Sources:<br>
</span><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sqlite.org%2Fwal.html%23advantages&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vrWFTUkAozdYRmNNtVRiMz5YiGTzAso2UQDgEzkzr6w%3D&reserved=0" target="_blank"><span lang="EN-US">Write-Ahead
Logging (sqlite.org)</span></a><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fr-spatial%2Fsf%2Fissues%2F628&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aC2PYy3vqIWzu3XXWMjhggZawmN9dXQcunqObizOQNY%3D&reserved=0" target="_blank"><span lang="EN-US">writing
gpkg and sqlite on samba shares fails · Issue #628 · r-spatial/sf · GitHub</span></a><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL"> <o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="790" style="width:592.5pt">
<tbody>
<tr>
<td width="790" valign="top" style="width:592.5pt;padding:0cm 0cm 11.25pt 0cm">
<p><strong><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#3D3C3F">_________________________________</span></strong><o:p></o:p></p>
<p><strong><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:#102B4D">Jarosław Sadowski</span></strong><span style="font-size:9.0pt;color:#102B4D"><br>
Kierownik Zespołu ds. Ochrony Środowiska | <em><span style="font-family:"Calibri",sans-serif">Biuro Strategii i Planowania, Projektowania i Inżynierii Podprogramu Kolejowego</span></em></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#102B4D"><br>
</span><em><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#102B4D">Environmental Protection Team Leader | Railway Subprogramme Strategy & Planning, Design & Engineering Department</span></em><span style="font-size:9.0pt;color:#102B4D"><br>
e: <a href="mailto:jaroslaw.sadowski@cpk.pl" target="_blank"><span style="color:#102B4D">jaroslaw.sadowski@cpk.pl</span></a><br>
m: +48 532 720 230</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td width="360" valign="top" style="width:270.0pt;padding:0cm 0cm 3.75pt 0cm">
<p><span style="font-size:5.0pt;font-family:"Arial",sans-serif"><img border="0" width="201" height="81" style="width:2.0937in;height:.8437in" id="m_-1341851179974007423Picture_x0020_1" src="cid:image001.png@01D958A5.729B5190"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL" style="font-size:5.0pt;color:#575757">Centralny Port Komunikacyjny Sp. z o.o. z siedzibą w Warszawie,
<a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.google.com%2Fmaps%2Fsearch%2FAleje%250D%250A%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2BJerozolimskie%2B142B%2C%2B02-305%2BWarszawa%3Fentry%3Dgmail%26source%3Dg&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bHlRUwTSYp%2F9iSSPfRvPoxdo8godq3BHOpLOleYg4AI%3D&reserved=0" target="_blank">
Aleje Jerozolimskie 142B, 02-305 Warszawa</a>; nr KRS 0000759991, Sąd Rejonowy dla
<a href="https://eur06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fm.st%2F&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=YC4lvRzDW7KLvQ9XNwKkx1LegwU4YpfZG7rm9jtxd1s%3D&reserved=0" target="_blank">
m.st</a>. Warszawy, XII Wydział Gospodarczy Krajowego Rejestru Sądowego; NIP 701-08-94-497; REGON 381918620; kapitał zakładowy 1.277.500.000,00 zł</span><span lang="PL"><br>
</span><span lang="PL" style="font-size:5.0pt;color:#575757">Administratorem danych osobowych przekazanych przez Panią/Pana m.in. w korespondencji mailowej jest Centralny Port Komunikacyjny Sp. z o.o. z siedzibą w Warszawie. Przetwarzamy dane osobowe zgodnie
z przepisami ogólnego rozporządzenia o ochronie danych (RODO), więcej informacji na ten temat znajduje się w zakładce Polityka Prywatności oraz w Klauzuli informacyjnej na stronie internetowej
</span><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.cpk.pl%2F&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uHuaO4hwhdJcCM8YgFGlTI%2F9jUJYElxlNC%2FGEanwNms%3D&reserved=0" target="_blank"><span style="font-size:5.0pt;color:#575757">www.cpk.pl</span></a></span><span lang="PL" style="font-size:5.0pt;color:#575757">.</span><span lang="PL"><br>
</span><span lang="PL" style="font-size:5.0pt;color:#575757">Treści zawarte w niniejszej wiadomości i załącznikach do niej stanowią Tajemnicę Przedsiębiorstwa w rozumieniu ustawy z dnia 16 kwietnia 1993 r. o zwalczaniu nieuczciwej konkurencji. Jeśli otrzymałeś
tę wiadomość przez pomyłkę, bezzwłocznie skontaktuj się z nadawcą wiadomości oraz usuń jej treść.
</span><span lang="PL"><br>
</span><span lang="PL" style="font-size:5.0pt;color:#575757">Centralny Port Komunikacyjny Sp. z o.o. with headquarters in
<a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.google.com%2Fmaps%2Fsearch%2FWarsaw%2C%2BAleje%250D%250A%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2B%2BJerozolimskie%2B142B%2C%2B02-305%2BWarsaw%3Fentry%3Dgmail%26source%3Dg&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=EvNnBNzkjbcbydKALT6iRX3LBul5gv3JY1CWwu%2FoREg%3D&reserved=0" target="_blank">
Warsaw, Aleje Jerozolimskie 142B, 02-305 Warsaw</a>; KRS No. 0000759991, District Court for the Capital City of Warsaw, 12th Commercial Department of the National Court Register; NIP 701-08-94-497; REGON 381918620; share capital of PLN 1.277.500.000,00.</span><span lang="PL"><br>
</span><span lang="PL" style="font-size:5.0pt;color:#575757">The personal data controller of the personal data provided by you, among others, in the e-mail correspondence, is Centralny Port Komunikacyjny Sp. z o. o. based in Warsaw. The personal data is processed
by us in accordance with the provisions of the General Data Protection Regulation (GDPR), for further information please read the Privacy Policy tab and the Information Clause on the
</span><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.cpk.pl%2F&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uHuaO4hwhdJcCM8YgFGlTI%2F9jUJYElxlNC%2FGEanwNms%3D&reserved=0" target="_blank"><span style="font-size:5.0pt;color:#575757">www.cpk.pl</span></a></span><span lang="PL" style="font-size:5.0pt;color:#575757">
website. </span><span lang="PL"><br>
</span><span lang="PL" style="font-size:5.0pt;color:#575757">The content of this message and its attachments constitute the Business Secret within the meaning of the Act of 16 April 1993 on combating unfair competition. If you received this message by mistake,
contact the sender of the message immediately and delete its content</span><span lang="PL">
<o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> QGIS-User <<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>>
<b>On Behalf Of </b>Árni Geirsson via QGIS-User<br>
<b>Sent:</b> Thursday, March 16, 2023 10:18 AM<br>
<b>To:</b> <a href="mailto:jhubbslist@att.net" target="_blank">jhubbslist@att.net</a><br>
<b>Cc:</b> <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> [EXTERNAL] Re: [Qgis-user] Geopackage slow on NAS if not read-only</span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt" id="m_-1341851179974007423m_-3721556285310908744m_-91705260448882375m_5292080438416008098m_-2869550827560755875m_448025373283784848m_-6768445286251198089footer">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:#FFEB9C">
<span lang="PL" style="color:black">UWAGA: Ta wiadomość pochodzi spoza CPK Sp. z o.o. Proszę pomóż zadbać o bezpieczeństwo naszej organizacji.
</span><span lang="EN-US" style="color:black">Zastanów się, zanim otworzysz link lub załącznik.</span><span lang="PL"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Yes, as far as I know, the NAS unit uses SMB as the file sharing protocol. I used another NAS from QNAP before this one, also using SMB and with the same problem.
I thought pretty much all of the Linux based NAS units were using SMB and if that is the problem, it should be widespread, but I don't see any signs of that. Is SMB a problem for geopackage?
</span><span lang="PL"><o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I did a quick test in QGIS: A dataset of 178.000 line features is rendered in about 1 second from a read only geopackage. When I remove the read only flag, it
is rendered in about 5 seconds.</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">If I store the geopackage on the local hard drive, the problem disappears, read-write or read-only does not matter.</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I have had suspicions about SMB being part of the problem but I don't know enough about file access deep down in the operating system to understand it.<br clear="all">
</span><span lang="PL"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="color:black">Árni Geirsson</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">On Thu, 16 Mar 2023 at 01:45, jhubbslist--- via QGIS-User <</span><span lang="PL"><a href="mailto:qgis-user@lists.osgeo.org" target="_blank"><span lang="EN-US">qgis-user@lists.osgeo.org</span></a></span><span lang="EN-US">>
wrote:</span><span lang="PL"><o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Árni -</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Are you using SMB/CIFS to access this NAS, and are you using wifi or Ethernet to connect to it?</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">- Jeff
</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">On 3/15/23 3:30 PM, Árni Geirsson via QGIS-User wrote:</span><span lang="PL"><o:p></o:p></span></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Hello all QGIS and geopackage users.
</span><span lang="PL"><o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I store my geopackages on a Synology RackStation NAS unit, like all other documents that are kept on a shared drive in the office. For larger datasets, the rendering
is very slow, unless I open the properties dialog for the file in Windows and check the read only box. After that, the features are rendered blazingly fast. Nothing else is changed to see the dramatic difference in the rendering speed. Luckily, I don't need
to edit many of the larger datasets, such as road networks and elevation contours and the geopackage can be kept read only. Shapefiles are not affected.</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">What explains this and does anyone know how to solve the problem? </span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Do other users experience this?</span><span lang="PL"><o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Árni Geirsson</span><span lang="PL"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span lang="PL"> <o:p></o:p></span></p>
<pre><span lang="EN-US">_______________________________________________</span><span lang="PL"><o:p></o:p></span></pre>
<pre><span lang="EN-US">QGIS-User mailing list</span><span lang="PL"><o:p></o:p></span></pre>
<pre><span lang="PL"><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><o:p></o:p></span></pre>
<pre><span lang="PL">List info: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353555137%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=zWL3lJDscTuLqjNO8Wi1oFcqS%2FsdczPZY3x1hiAYyBM%3D&reserved=0" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></pre>
<pre><span lang="EN-US">Unsubscribe: </span><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><o:p></o:p></span></pre>
</blockquote>
<p><span lang="EN-US"> </span><span lang="PL"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">_______________________________________________<br>
QGIS-User mailing list<br>
</span><span lang="PL"><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank"><span lang="EN-US">QGIS-User@lists.osgeo.org</span></a></span><span lang="EN-US"><br>
List info: </span><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a></span><span lang="EN-US"><br>
Unsubscribe: </span><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><o:p></o:p></span></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span lang="PL"><o:p> </o:p></span></p>
<pre><span lang="PL">_______________________________________________<o:p></o:p></span></pre>
<pre><span lang="PL">QGIS-User mailing list<o:p></o:p></span></pre>
<pre><span lang="PL"><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><o:p></o:p></span></pre>
<pre><span lang="PL">List info: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></pre>
<pre><span lang="PL">Unsubscribe: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></pre>
</blockquote>
<pre><span lang="PL">-- <o:p></o:p></span></pre>
<pre><span lang="PL">Jorge Gustavo Rocha<o:p></o:p></span></pre>
<pre><span lang="PL">Geomaster, LDA<o:p></o:p></span></pre>
<pre><span lang="PL">"Take the open source journey with us"<o:p></o:p></span></pre>
<pre><span lang="PL"> <o:p></o:p></span></pre>
<pre><span lang="PL">VAT/NIF: PT 510 906 109<o:p></o:p></span></pre>
<pre><span lang="PL">Phone: +351 253 257 173 (landline)<o:p></o:p></span></pre>
<pre><span lang="PL">Mobile: +351 910 333 888 (cellular)<o:p></o:p></span></pre>
<pre><span lang="PL"> <o:p></o:p></span></pre>
<pre><span lang="PL"><a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.google.com%2Fmaps%2Fsearch%2FRua%2BAfonso%2BPalmeira%2C%2B31%2C%2B7%3Fentry%3Dgmail%26source%3Dg&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Gghx2QBaFcLS6wBLy1a9MuExneqWyKKIldi0ExKgwA4%3D&reserved=0" target="_blank">Rua Afonso Palmeira, 31, 7</a> D<o:p></o:p></span></pre>
<pre><span lang="PL">4715-278 Braga<o:p></o:p></span></pre>
<pre><span lang="PL">PORTUGAL<o:p></o:p></span></pre>
<pre><span lang="PL">GPS 41.54627, -8.40432<o:p></o:p></span></pre>
<pre><span lang="PL"> <o:p></o:p></span></pre>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></p>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></p>
</blockquote>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">--
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="PL">Sent from a phone. Amazing! But possibly garbled. Sebastian Gutwein Regenerative Design Group 1 Chevalier Ave Greenfield MA
<a href="mailto:Bas@rdgland.com" target="_blank">Bas@rdgland.com</a> (631) 241-1018<o:p></o:p></span></p>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span lang="PL"><o:p> </o:p></span></p>
<pre><span lang="PL">_______________________________________________<o:p></o:p></span></pre>
<pre><span lang="PL">QGIS-User mailing list<o:p></o:p></span></pre>
<pre><span lang="PL"><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><o:p></o:p></span></pre>
<pre><span lang="PL">List info: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></pre>
<pre><span lang="PL">Unsubscribe: <a href="https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cjaroslaw.sadowski%40cpk.pl%7Cd767a39352fb48744fbc08db26235086%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145705353712104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mW4NbdtL2GFA1o2wNdAzIeEra7oa6XFo010WXMpypvU%3D&reserved=0" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></span></pre>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</body>
</html>