<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi,</p>
<p>For data storage and manipulation databases are suitable. Files
are not. <br>
</p>
<p>Geopackages are wonderful to transfer data between systems or to
archive an entire project (snapshot of data, styles and the
project itself).</p>
<p>Regards,</p>
<p>Jorge<br>
</p>
<div class="moz-cite-prefix">On 16/03/23 11:30, Árni Geirsson via
QGIS-User wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CALtMHXjL6GbYPa2-P4U9bHWGBcUUxfhL8dmCEKX9UUmHVWhTBA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">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.
<div>Should this perhaps be discussed in another forum, closer
to the development of geopackage/sqlite?<br clear="all">
<div>
<div dir="ltr" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<font
color="#000000">Árni
Geirsson</font><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, 16 Mar 2023 at 09:52,
Sadowski Jarosław <<a
href="mailto:jaroslaw.sadowski@cpk.pl" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">jaroslaw.sadowski@cpk.pl</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div lang="PL">
<div>
<p class="MsoNormal"><span lang="EN-US">Long story
short: gpkg is bad idea for network drives as
SMB/NAS etc</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Sources:<br>
</span><a
href="https://www.sqlite.org/wal.html#advantages"
target="_blank" moz-do-not-send="true"><span
lang="EN-US">Write-Ahead Logging (sqlite.org)</span></a></p>
<p class="MsoNormal"><a
href="https://github.com/r-spatial/sf/issues/628"
target="_blank" moz-do-not-send="true"><span
lang="EN-US">writing gpkg and sqlite on samba
shares fails · Issue #628 · r-spatial/sf · GitHub</span></a></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></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:rgb(61,60,63);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:rgb(16,43,77)"><font
style="color:rgb(16,43,77)" face="Calibri"><strong
style="font-size:10pt;color:rgb(16,43,77)">Jarosław
Sadowski</strong><br>
<span
style="font-family:Calibri;color:rgb(16,43,77)">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:rgb(16,43,77)"><em>Environmental
Protection Team Leader </em></span><span
style="font-family:Calibri;color:rgb(16,43,77)"><em>| Railway
Subprogramme Strategy & Planning,
Design & Engineering Department</em><br>
</span><span
style="font-size:9pt;font-family:Calibri;color:rgb(16,43,77)">e:
<a
style="font-size:9pt;font-family:Calibri;color:rgb(16,43,77)"
href="mailto:jaroslaw.sadowski@cpk.pl"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">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:part1.9U6G2Bv9.033qFjli@geomaster.pt"
id="m_448025373283784848m_-67684452862511980890.ylacelzjqfh"
style="font-size: 5pt;" class="" border="0"></p>
</td>
</tr>
</tbody>
</table>
<font face="Calibri" color="#575757"><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 <a href="http://m.st"
target="_blank" moz-do-not-send="true">m.st</a>.
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 face="Calibri" color="#575757"><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/" target="_blank"
moz-do-not-send="true">www.cpk.pl</a><font
face="Calibri" color="#575757"><span
style="font-size:5pt">.</span></font><br>
<font face="Calibri" color="#575757"><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 face="Calibri" color="#575757"><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 face="Calibri" color="#575757"><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/" target="_blank"
moz-do-not-send="true">www.cpk.pl</a><font
face="Calibri" color="#575757"><span
style="font-size:5pt"> website. </span></font><br>
<font face="Calibri" color="#575757"><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-right:none;border-bottom:none;border-left:none;border-top:1pt
solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal"><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" moz-do-not-send="true"
class="moz-txt-link-freetext">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" moz-do-not-send="true"
class="moz-txt-link-freetext">jhubbslist@att.net</a><br>
<b>Cc:</b> <a
href="mailto:qgis-user@lists.osgeo.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> [EXTERNAL] Re: [Qgis-user]
Geopackage slow on NAS if not read-only</span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<div style="border:1pt solid rgb(156,101,0);padding:2pt"
id="m_448025373283784848m_-6768445286251198089footer">
<p class="MsoNormal"
style="background:rgb(255,235,156)"><span
style="color:black">UWAGA: Ta wiadomość pochodzi
spoza CPK Sp. z o.o. Proszę pomóż zadbać o
bezpieczeństwo naszej organizacji.
</span><span style="color:black" lang="EN-US">Zastanów
się, zanim otworzysz link lub załącznik.</span><span
lang="EN-US"></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12pt"><span
lang="EN-US"> </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?
</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.</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.</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">
</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"> </span></p>
</div>
<p
class="MsoNormal"><span
style="color:black" lang="EN-US">Árni Geirsson</span><span lang="EN-US"></span></p>
</div>
<div>
<p
class="MsoNormal"><span
lang="EN-US"> </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"> </span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"> </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" moz-do-not-send="true"><span
lang="EN-US">qgis-user@lists.osgeo.org</span></a><span
lang="EN-US">> wrote:</span></p>
</div>
<blockquote
style="border-top:none;border-right:none;border-bottom:none;border-left:1pt
solid rgb(204,204,204);padding:0cm 0cm 0cm
6pt;margin:5pt 0cm 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Árni -</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </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?</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">- Jeff
</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">On
3/15/23 3:30 PM, Árni Geirsson via
QGIS-User wrote:</span></p>
</div>
<blockquote
style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal"><span lang="EN-US">Hello
all QGIS and geopackage users. </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.</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">What
explains this and does anyone know how
to solve the problem? </span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">Do
other users experience this?</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"> </span></p>
</div>
<p
class="MsoNormal"><span
lang="EN-US">Árni
Geirsson</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>
</span></p>
<pre><span lang="EN-US">_______________________________________________</span></pre>
<pre><span lang="EN-US">QGIS-User mailing list</span></pre>
<pre><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">QGIS-User@lists.osgeo.org</a></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" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></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" moz-do-not-send="true"><span lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-US"></span></pre>
</blockquote>
<p><span lang="EN-US"> </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" moz-do-not-send="true"><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" moz-do-not-send="true"><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" moz-do-not-send="true"><span
lang="EN-US">https://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span
lang="EN-US"></span></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></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>
<pre class="moz-signature" cols="72">--
Jorge Gustavo Rocha
Geomaster, LDA
"Take the open source journey with us"
VAT/NIF: PT 510 906 109
Phone: +351 253 257 173 (landline)
Mobile: +351 910 333 888 (cellular)
Rua Afonso Palmeira, 31, 7 D
4715-278 Braga
PORTUGAL
GPS 41.54627, -8.40432
</pre>
</body>
</html>