<div dir="ltr">Hi Jorge<div>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"><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</font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">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:<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>
<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>On 16/03/23 11:30, Árni Geirsson via
QGIS-User wrote:<br>
</div>
<blockquote type="cite">
<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">
<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">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"><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"><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">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:186ea42b797c23ac9e51" id="m_5292080438416008098m_-2869550827560755875m_448025373283784848m_-67684452862511980890.ylacelzjqfh" style="font-size: 5pt;" 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">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">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">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">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></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_5292080438416008098m_-2869550827560755875m_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"><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">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">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"><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"><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"></span></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
QGIS-User mailing list
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre 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>
</div>
_______________________________________________<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" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div>