<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=iso-8859-2">
<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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 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 Preformatted Char";
margin:0cm;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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="PL" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Long story short: gpkg is bad idea for network drives as SMB/NAS etc<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Sources:<br>
</span><a href="https://www.sqlite.org/wal.html#advantages"><span lang="EN-US">Write-Ahead Logging (sqlite.org)</span></a><o:p></o:p></p>
<p class="MsoNormal"><a href="https://github.com/r-spatial/sf/issues/628"><span lang="EN-US">writing gpkg and sqlite on samba shares fails · Issue #628 · r-spatial/sf · GitHub</span></a><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></p><br>
<table style="WIDTH: 790px" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; WIDTH: 790px; COLOR: #3d3c3f; PADDING-BOTTOM: 15px" valign="top">
<p style="FONT-SIZE: 9pt; FONT-FAMILY: Arial"><font face="Calibri"><strong>_________________________________</strong></font></p>
<p style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; COLOR: #102b4d"><font style="COLOR: #102b4d" face="Calibri"><strong style="FONT-SIZE: 10pt; COLOR: #102b4d">Jarosław Sadowski</strong><br><span style="FONT-FAMILY: Calibri; COLOR: #102b4d">Kierownik Zespołu ds. Ochrony Środowiska
|<span style="color: rgb(16, 43, 77);"> </span></span></font><em style="FONT-FAMILY: Calibri; COLOR: rgb(87,87,87)"><span style="color: rgb(16, 43, 77);">Biuro Strategii i Planowania, Projektowania i Inżynierii Podprogramu Kolejowego</span></em><br><span style="FONT-FAMILY: Calibri; COLOR: #102b4d"><em>Environmental Protection Team Leader
</em></span><span style="FONT-FAMILY: Calibri; COLOR: #102b4d"><em>|
Railway Subprogramme Strategy & Planning, Design & Engineering Department</em><br></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; COLOR: #102b4d">e: <a style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; COLOR: #102b4d" href="mailto:jaroslaw.sadowski@cpk.pl">jaroslaw.sadowski@cpk.pl</a><br>m:
+48 532 720 230</span></p></td></tr>
<tr>
<td style="FONT-SIZE: 5pt; FONT-FAMILY: Arial; WIDTH: 360px; PADDING-BOTTOM: 5px" valign="top">
<p style="FONT-SIZE: 5pt; FONT-FAMILY: Arial"><img src="cid:transparency_ce4012c8-87e7-4198-a48f-d42a38680681.png" border="0" id="0.ylacelzjqfh" style="font-size: 5pt;"></p></td></tr></tbody></table><font color="#575757" face="Calibri"><span style="font-size: 5pt;">Centralny Port
Komunikacyjny Sp. z o.o. z siedzibą w Warszawie, Aleje Jerozolimskie 142B,
02-305 Warszawa; nr KRS 0000759991, Sąd Rejonowy dla m.st. Warszawy, XII Wydział
Gospodarczy Krajowego Rejestru Sądowego; NIP 701-08-94-497; REGON 381918620;
kapitał zakładowy </span><span style="font-size: 6.66667px;">1.277.500.000,00</span><span style="font-size: 5pt;"> zł</span></font><br><font color="#575757" face="Calibri"><span style="font-size: 5pt;">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></font><a style="color: rgb(87, 87, 87); font-family: Calibri; font-size: 5pt;" href="http://www.cpk.pl/">www.cpk.pl</a><font color="#575757" face="Calibri"><span style="font-size: 5pt;">.</span></font><br><font color="#575757" face="Calibri"><span style="font-size: 5pt;">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></font><br><font color="#575757" face="Calibri"><span style="font-size: 5pt;">Centralny Port Komunikacyjny Sp. z o.o. with headquarters
in Warsaw, Aleje Jerozolimskie 142B, 02-305 Warsaw; 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 </span><span style="font-size: 6.66667px;">1.277.500.000,00</span><span style="font-size: 5pt;">.</span></font><br><font color="#575757" face="Calibri"><span style="font-size: 5pt;">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></font><a style="color: rgb(87, 87, 87); font-family: Calibri; font-size: 5pt;" href="http://www.cpk.pl/">www.cpk.pl</a><font color="#575757" face="Calibri"><span style="font-size: 5pt;"> website. </span></font><br><font color="#575757" face="Calibri"><span style="font-size: 5pt;">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></font>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> QGIS-User <qgis-user-bounces@lists.osgeo.org>
<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> jhubbslist@att.net<br>
<b>Cc:</b> qgis-user@lists.osgeo.org<br>
<b>Subject:</b> [EXTERNAL] Re: [Qgis-user] Geopackage slow on NAS if not read-only<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div style="border:solid #9C6500 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt" id="footer">
<p class="MsoNormal" style="background:#FFEB9C"><span 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="EN-US"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal"><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?
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><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">
<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"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US" style="color:black">Árni Geirsson</span><span lang="EN-US"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><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"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">On Thu, 16 Mar 2023 at 01:45, jhubbslist--- via QGIS-User <</span><a href="mailto:qgis-user@lists.osgeo.org" target="_blank"><span lang="EN-US">qgis-user@lists.osgeo.org</span></a><span lang="EN-US">> 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>
<p class="MsoNormal"><span lang="EN-US">Árni -<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">Are you using SMB/CIFS to access this NAS, and are you using wifi or Ethernet to connect to it?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">- Jeff <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">On 3/15/23 3:30 PM, Á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"><span lang="EN-US">Hello all QGIS and geopackage users. <o:p>
</o:p></span></p>
<div>
<p class="MsoNormal"><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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">What explains this and does anyone know how to solve the problem? <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">Do other users experience this?<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"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US">Árni Geirsson<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"><span lang="EN-US"><br>
<br>
<o:p></o:p></span></p>
<pre><span lang="EN-US">_______________________________________________<o:p></o:p></span></pre>
<pre><span lang="EN-US">QGIS-User mailing list<o:p></o:p></span></pre>
<pre><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><o:p></o:p></pre>
<pre>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%7C11269f199d644f13364608db25ff69c5%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145551176051605%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4NfOOZrB2k%2B7Q3V0QHNXIvEOTYHFWp4D10C1MzYTTQQ%3D&reserved=0" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre><span lang="EN-US">Unsubscribe: </span><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%7C11269f199d644f13364608db25ff69c5%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145551176051605%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4NfOOZrB2k%2B7Q3V0QHNXIvEOTYHFWp4D10C1MzYTTQQ%3D&reserved=0" target="_blank"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-US"><o:p></o:p></span></pre>
</blockquote>
<p><span lang="EN-US"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US">_______________________________________________<br>
QGIS-User mailing list<br>
</span><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank"><span lang="EN-US">QGIS-User@lists.osgeo.org</span></a><span lang="EN-US"><br>
List info: </span><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%7C11269f199d644f13364608db25ff69c5%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145551176051605%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4NfOOZrB2k%2B7Q3V0QHNXIvEOTYHFWp4D10C1MzYTTQQ%3D&reserved=0" target="_blank"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-US"><br>
Unsubscribe: </span><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%7C11269f199d644f13364608db25ff69c5%7Cfa798250ca0b4a1bb47381cff4a1752b%7C1%7C0%7C638145551176051605%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4NfOOZrB2k%2B7Q3V0QHNXIvEOTYHFWp4D10C1MzYTTQQ%3D&reserved=0" target="_blank"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-US"><o:p></o:p></span></p>
</blockquote>
</div>
</div>
</div>
</body>
</html>