<div dir='auto'></div><div class="gmail_extra"><br><div class="gmail_quote">On 16 Mar 2023 13:04, qgis-user-request@lists.osgeo.org wrote:<br type="attribution" /><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Send QGIS-User mailing list submissions to
<br>
qgis-user@lists.osgeo.org
<br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit
<br>
https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
or, via email, send a message with subject or body 'help' to
<br>
qgis-user-request@lists.osgeo.org
<br>
<br>
You can reach the person managing the list at
<br>
qgis-user-owner@lists.osgeo.org
<br>
<br>
When replying, please edit your Subject line so it is more specific
<br>
than "Re: Contents of QGIS-User digest..."
<br>
<br>
<br>
Today's Topics:
<br>
<br>
1. Re: [EXTERNAL] Re: Geopackage slow on NAS if not read-only
<br>
(Jorge Gustavo Rocha)
<br>
2. Transformation of vertical datum for points (Bo Victor Thomsen)
<br>
3. Re: [EXTERNAL] Re: Geopackage slow on NAS if not read-only
<br>
(?rni Geirsson)
<br>
<br>
<br>
----------------------------------------------------------------------
<br>
<br>
Message: 1
<br>
Date: Thu, 16 Mar 2023 11:47:23 +0000
<br>
From: Jorge Gustavo Rocha <jgr@geomaster.pt>
<br>
To: qgis-user@lists.osgeo.org
<br>
Subject: Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not
<br>
read-only
<br>
Message-ID: <02cff8cb-3037-8e4e-408c-eece984850fa@geomaster.pt>
<br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"
<br>
<br>
Hi,
<br>
<br>
For data storage and manipulation databases are suitable. Files are not.
<br>
<br>
Geopackages are wonderful to transfer data between systems or to archive
<br>
an entire project (snapshot of data, styles and the project itself).
<br>
<br>
Regards,
<br>
<br>
Jorge
<br>
<br>
On 16/03/23 11:30, ?rni Geirsson via QGIS-User wrote:
<br>
> Thank you?Jaros?aw. Isn't it strange that this was discussed 5 years
<br>
> ago and SMB file sharing is very common? Would a linux based NAS be
<br>
> able to use another protocol? What are my options for file?based data
<br>
> sharing in?QGIS? Abandoning geopackages is not a realistic option for
<br>
> me, but I could get a different kind of NAS unit, if that helps,?what
<br>
> kind then? What amazes me is how little I see this discussed. There
<br>
> was a message in this thread this morning from?Thomas Struller, but I
<br>
> am not sure it is about the same root problem, maybe Thomas can
<br>
> elaborate.
<br>
> Should this perhaps be discussed in another forum, closer to the
<br>
> development of geopackage/sqlite?
<br>
>
<br>
> ?rni Geirsson
<br>
>
<br>
> On Thu, 16 Mar 2023 at 09:52, Sadowski Jaros?aw
<br>
> <jaroslaw.sadowski@cpk.pl> wrote:
<br>
>
<br>
> Long story short: gpkg is bad idea for network drives as SMB/NAS etc
<br>
>
<br>
> Sources:
<br>
> Write-Ahead Logging (sqlite.org)
<br>
> <https://www.sqlite.org/wal.html#advantages>
<br>
>
<br>
> writing gpkg and sqlite on samba shares fails ? Issue #628 ?
<br>
> r-spatial/sf ? GitHub <https://github.com/r-spatial/sf/issues/628>
<br>
>
<br>
>
<br>
> *_________________________________*
<br>
>
<br>
> *Jaros?aw Sadowski*
<br>
> Kierownik Zespo?u ds. Ochrony ?rodowiska |/Biuro Strategii i
<br>
> Planowania, Projektowania i In?ynierii Podprogramu Kolejowego/
<br>
> /Environmental Protection Team Leader //| Railway Subprogramme
<br>
> Strategy & Planning, Design & Engineering Department/
<br>
> e: jaroslaw.sadowski@cpk.pl
<br>
> m: +48 532 720 230
<br>
>
<br>
> Centralny Port Komunikacyjny Sp. z o.o. z siedzib? w Warszawie,
<br>
> Aleje Jerozolimskie 142B, 02-305 Warszawa; nr KRS 0000759991, S?d
<br>
> Rejonowy dla m.st <http://m.st>. Warszawy, XII Wydzia? Gospodarczy
<br>
> Krajowego Rejestru S?dowego; NIP 701-08-94-497; REGON 381918620;
<br>
> kapita? zak?adowy 1.277.500.000,00?z?
<br>
> Administratorem danych osobowych przekazanych przez Pani?/Pana
<br>
> m.in. w korespondencji mailowej jest Centralny Port Komunikacyjny
<br>
> Sp. z o.o. z siedzib? w Warszawie. Przetwarzamy dane osobowe
<br>
> zgodnie z przepisami og?lnego rozporz?dzenia o ochronie danych
<br>
> (RODO), wi?cej informacji na ten temat znajduje si? w zak?adce
<br>
> Polityka Prywatno?ci oraz w Klauzuli informacyjnej na stronie
<br>
> internetowej www.cpk.pl <http://www.cpk.pl/>.
<br>
> Tre?ci zawarte w niniejszej wiadomo?ci i za??cznikach do niej
<br>
> stanowi? Tajemnic? Przedsi?biorstwa w rozumieniu ustawy z dnia 16
<br>
> kwietnia 1993 r. o zwalczaniu nieuczciwej konkurencji. Je?li
<br>
> otrzyma?e? t? wiadomo?? przez pomy?k?, bezzw?ocznie skontaktuj si?
<br>
> z nadawc? wiadomo?ci oraz usu? jej tre??.
<br>
> Centralny Port Komunikacyjny Sp. z o.o. with headquarters in
<br>
> Warsaw, Aleje Jerozolimskie 142B, 02-305 Warsaw; KRS No.
<br>
> 0000759991, District Court for the Capital City of Warsaw, 12th
<br>
> Commercial Department of the National Court Register; NIP
<br>
> 701-08-94-497; REGON 381918620; share capital of PLN 1.277.500.000,00.
<br>
> The personal data controller of the personal data provided by you,
<br>
> among others, in the e-mail correspondence, is Centralny Port
<br>
> Komunikacyjny Sp. z o. o. based in Warsaw. The personal data is
<br>
> processed by us in accordance with the provisions of the General
<br>
> Data Protection Regulation (GDPR), for further information please
<br>
> read the Privacy Policy tab and the Information Clause on the
<br>
> www.cpk.pl <http://www.cpk.pl/>website.
<br>
> The content of this message and its attachments constitute the
<br>
> Business Secret within the meaning of the Act of 16 April 1993 on
<br>
> combating unfair competition. If you received this message by
<br>
> mistake, contact the sender of the message immediately and delete
<br>
> its content
<br>
>
<br>
> *From:*QGIS-User <qgis-user-bounces@lists.osgeo.org> *On Behalf Of
<br>
> *?rni Geirsson via QGIS-User
<br>
> *Sent:* Thursday, March 16, 2023 10:18 AM
<br>
> *To:* jhubbslist@att.net
<br>
> *Cc:* qgis-user@lists.osgeo.org
<br>
> *Subject:* [EXTERNAL] Re: [Qgis-user] Geopackage slow on NAS if
<br>
> not read-only
<br>
>
<br>
> UWAGA: Ta wiadomo?? pochodzi spoza CPK Sp. z o.o. Prosz? pom??
<br>
> zadba? o bezpiecze?stwo naszej organizacji. Zastan?w si?, zanim
<br>
> otworzysz link lub za??cznik.
<br>
>
<br>
> Yes, as far as?I know, the NAS unit?uses SMB as the file sharing
<br>
> protocol. I used another NAS from QNAP before this one, also using
<br>
> SMB and with the same problem. I thought pretty much all of the
<br>
> Linux based NAS units were using SMB and if that is the problem,
<br>
> it should be widespread, but I don't see any signs of that. Is SMB
<br>
> a problem for geopackage?
<br>
>
<br>
> I did a quick test in QGIS: A dataset of 178.000 line features is
<br>
> rendered in about 1 second from a read only geopackage. When I
<br>
> remove the read only flag, it is rendered in about 5 seconds.
<br>
>
<br>
> If I store the geopackage on the local hard drive, the problem
<br>
> disappears, read-write or read-only does not matter.
<br>
>
<br>
> I have had suspicions about SMB being part of the problem but I
<br>
> don't know enough about file access deep down in the operating
<br>
> system to understand it.
<br>
>
<br>
> ?rni Geirsson
<br>
>
<br>
> On Thu, 16 Mar 2023 at 01:45, jhubbslist--- via QGIS-User
<br>
> <qgis-user@lists.osgeo.org <mailto:qgis-user@lists.osgeo.org>> wrote:
<br>
>
<br>
> ?rni -
<br>
>
<br>
> Are you using SMB/CIFS to access this NAS, and are you using
<br>
> wifi or Ethernet to connect to it?
<br>
>
<br>
> - Jeff
<br>
>
<br>
> On 3/15/23 3:30 PM, ?rni Geirsson via QGIS-User wrote:
<br>
>
<br>
> Hello all QGIS and geopackage users.
<br>
>
<br>
> I store my geopackages on a Synology RackStation NAS unit,
<br>
> like all other documents that are kept on a shared drive
<br>
> in the office. For larger datasets, the rendering is very
<br>
> slow, unless I open the properties dialog for the file in
<br>
> Windows and check the read only box. After that, the
<br>
> features are rendered blazingly fast. Nothing else is
<br>
> changed to see the dramatic difference in the rendering
<br>
> speed. Luckily, I don't need to edit many of the larger
<br>
> datasets, such as road networks and elevation contours and
<br>
> the?geopackage can be kept read only. Shapefiles are not
<br>
> affected.
<br>
>
<br>
> What explains this and does anyone know how to solve
<br>
> the?problem?
<br>
>
<br>
> Do other users experience?this?
<br>
>
<br>
> ?rni Geirsson
<br>
>
<br>
>
<br>
>
<br>
> _______________________________________________
<br>
>
<br>
> QGIS-User mailing list
<br>
>
<br>
> QGIS-User@lists.osgeo.org
<br>
>
<br>
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user <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>
<br>
>
<br>
> Unsubscribe:
<br>
> https://lists.osgeo.org/mailman/listinfo/qgis-user <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>
<br>
>
<br>
> _______________________________________________
<br>
> QGIS-User mailing list
<br>
> QGIS-User@lists.osgeo.org <mailto:QGIS-User@lists.osgeo.org>
<br>
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
> <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>
<br>
> Unsubscribe:
<br>
> https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
> <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>
<br>
>
<br>
>
<br>
> _______________________________________________
<br>
> QGIS-User mailing list
<br>
> QGIS-User@lists.osgeo.org
<br>
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
<br>
--
<br>
Jorge Gustavo Rocha
<br>
Geomaster, LDA
<br>
"Take the open source journey with us"
<br>
<br>
VAT/NIF: PT 510 906 109
<br>
Phone: +351 253 257 173 (landline)
<br>
Mobile: +351 910 333 888 (cellular)
<br>
<br>
Rua Afonso Palmeira, 31, 7 D
<br>
4715-278 Braga
<br>
PORTUGAL
<br>
GPS 41.54627, -8.40432
<br>
-------------- next part --------------
<br>
An HTML attachment was scrubbed...
<br>
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230316/0c804667/attachment-0001.htm>
<br>
-------------- next part --------------
<br>
A non-text attachment was scrubbed...
<br>
Name: transparency_ce4012c8-87e7-4198-a48f-d42a38680681.png
<br>
Type: image/png
<br>
Size: 2458 bytes
<br>
Desc: not available
<br>
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230316/0c804667/attachment-0001.png>
<br>
<br>
------------------------------
<br>
<br>
Message: 2
<br>
Date: Thu, 16 Mar 2023 13:02:39 +0100
<br>
From: Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
<br>
To: qgis-user@lists.osgeo.org
<br>
Subject: [Qgis-user] Transformation of vertical datum for points
<br>
Message-ID: <2516d0b6-2b67-b9c4-6f18-8921d9733b96@gmail.com>
<br>
Content-Type: text/plain; charset=UTF-8; format=flowed
<br>
<br>
Hi list -
<br>
<br>
I have a question regarding transformation of ellisoid heights to geoid
<br>
heights..
<br>
<br>
I have a dataset consisting of points, where the z coordinate is a
<br>
attribute column for the layer. (If necessary, this can be changed to a
<br>
3 dimensional layer type - or the x, y values can be placed i 2
<br>
attribute columns - whatever)
<br>
<br>
The data is in EPSG:32825 (UTM32N/ETRS89) and the present height values
<br>
are ellisoid height values for this CRS.
<br>
<br>
I would like to transform the height values the the corresponding DVR90
<br>
( EPSG:5799) geoid height values
<br>
<br>
Can this be done in QGIS using some kind of expression function. Or
<br>
using ogr2ogr ? or Postgis ??
<br>
<br>
--
<br>
Med venlig hilsen / Best regards
<br>
<br>
Bo Victor Thomsen
<br>
<br>
<br>
<br>
------------------------------
<br>
<br>
Message: 3
<br>
Date: Thu, 16 Mar 2023 12:04:04 +0000
<br>
From: ?rni Geirsson <arni@alta.is>
<br>
To: Jorge Gustavo Rocha <jgr@geomaster.pt>
<br>
Cc: qgis-user@lists.osgeo.org
<br>
Subject: Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not
<br>
read-only
<br>
Message-ID:
<br>
<CALtMHXiTNp-Xsa8DGg8mwXoXiDG9mYgjPD05rE41kH+jYB-W3w@mail.gmail.com>
<br>
Content-Type: text/plain; charset="utf-8"
<br>
<br>
Hi Jorge
<br>
I understand what you are pointing at and I use databases such as
<br>
Postgres/PostGIS also with good results. The thing is that working with
<br>
data in files sometimes has advantages and that is certainly how shapefiles
<br>
have been used. The geopackage has been suggested as a replacement for the
<br>
shapefile in the context of regular QGIS usage without any caveat saying
<br>
that geopackages only replace the storage and transfer role of shapefiles
<br>
and that geopackages should not be used for editing in a shared
<br>
environment, as is perfectly possible with shapefiles and widely practiced.
<br>
Not all users have access to database systems such as Postgres. I'm just
<br>
looking for some clarity on best practices for the common scenario of
<br>
working with QGIS using file based data in a network environment.
<br>
<br>
?rni
<br>
<br>
<br>
On Thu, 16 Mar 2023 at 11:47, Jorge Gustavo Rocha via QGIS-User <
<br>
qgis-user@lists.osgeo.org> wrote:
<br>
<br>
> Hi,
<br>
>
<br>
> For data storage and manipulation databases are suitable. Files are not.
<br>
>
<br>
> Geopackages are wonderful to transfer data between systems or to archive
<br>
> an entire project (snapshot of data, styles and the project itself).
<br>
>
<br>
> Regards,
<br>
>
<br>
> Jorge
<br>
> On 16/03/23 11:30, ?rni Geirsson via QGIS-User wrote:
<br>
>
<br>
> Thank you Jaros?aw. Isn't it strange that this was discussed 5 years ago
<br>
> and SMB file sharing is very common? Would a linux based NAS be able to use
<br>
> another protocol? What are my options for file based data sharing in QGIS?
<br>
> Abandoning geopackages is not a realistic option for me, but I could get a
<br>
> different kind of NAS unit, if that helps, what kind then? What amazes me
<br>
> is how little I see this discussed. There was a message in this thread this
<br>
> morning from Thomas Struller, but I am not sure it is about the same root
<br>
> problem, maybe Thomas can elaborate.
<br>
> Should this perhaps be discussed in another forum, closer to the
<br>
> development of geopackage/sqlite?
<br>
>
<br>
> ?rni Geirsson
<br>
>
<br>
> On Thu, 16 Mar 2023 at 09:52, Sadowski Jaros?aw <jaroslaw.sadowski@cpk.pl>
<br>
> wrote:
<br>
>
<br>
>> Long story short: gpkg is bad idea for network drives as SMB/NAS etc
<br>
>>
<br>
>>
<br>
>>
<br>
>> Sources:
<br>
>> Write-Ahead Logging (sqlite.org)
<br>
>> <https://www.sqlite.org/wal.html#advantages>
<br>
>>
<br>
>> writing gpkg and sqlite on samba shares fails ? Issue #628 ? r-spatial/sf
<br>
>> ? GitHub <https://github.com/r-spatial/sf/issues/628>
<br>
>>
<br>
>>
<br>
>>
<br>
>>
<br>
>>
<br>
>> *_________________________________*
<br>
>>
<br>
>> *Jaros?aw Sadowski*
<br>
>> Kierownik Zespo?u ds. Ochrony ?rodowiska | *Biuro Strategii i
<br>
>> Planowania, Projektowania i In?ynierii Podprogramu Kolejowego*
<br>
>> *Environmental Protection Team Leader **| Railway Subprogramme Strategy
<br>
>> & Planning, Design & Engineering Department*
<br>
>> e: jaroslaw.sadowski@cpk.pl
<br>
>> m: +48 532 720 230
<br>
>>
<br>
>> Centralny Port Komunikacyjny Sp. z o.o. z siedzib? w Warszawie, Aleje
<br>
>> Jerozolimskie 142B, 02-305 Warszawa; nr KRS 0000759991, S?d Rejonowy dla
<br>
>> m.st. Warszawy, XII Wydzia? Gospodarczy Krajowego Rejestru S?dowego; NIP
<br>
>> 701-08-94-497; REGON 381918620; kapita? zak?adowy 1.277.500.000,00 z?
<br>
>> Administratorem danych osobowych przekazanych przez Pani?/Pana m.in. w
<br>
>> korespondencji mailowej jest Centralny Port Komunikacyjny Sp. z o.o. z
<br>
>> siedzib? w Warszawie. Przetwarzamy dane osobowe zgodnie z przepisami
<br>
>> og?lnego rozporz?dzenia o ochronie danych (RODO), wi?cej informacji na ten
<br>
>> temat znajduje si? w zak?adce Polityka Prywatno?ci oraz w Klauzuli
<br>
>> informacyjnej na stronie internetowej www.cpk.pl.
<br>
>> Tre?ci zawarte w niniejszej wiadomo?ci i za??cznikach do niej stanowi?
<br>
>> Tajemnic? Przedsi?biorstwa w rozumieniu ustawy z dnia 16 kwietnia 1993 r. o
<br>
>> zwalczaniu nieuczciwej konkurencji. Je?li otrzyma?e? t? wiadomo?? przez
<br>
>> pomy?k?, bezzw?ocznie skontaktuj si? z nadawc? wiadomo?ci oraz usu? jej
<br>
>> tre??.
<br>
>> Centralny Port Komunikacyjny Sp. z o.o. with headquarters in Warsaw,
<br>
>> Aleje Jerozolimskie 142B, 02-305 Warsaw; KRS No. 0000759991, District Court
<br>
>> for the Capital City of Warsaw, 12th Commercial Department of the National
<br>
>> Court Register; NIP 701-08-94-497; REGON 381918620; share capital of PLN
<br>
>> 1.277.500.000,00.
<br>
>> The personal data controller of the personal data provided by you, among
<br>
>> others, in the e-mail correspondence, is Centralny Port Komunikacyjny Sp. z
<br>
>> o. o. based in Warsaw. The personal data is processed by us in accordance
<br>
>> with the provisions of the General Data Protection Regulation (GDPR), for
<br>
>> further information please read the Privacy Policy tab and the Information
<br>
>> Clause on the www.cpk.pl website.
<br>
>> The content of this message and its attachments constitute the Business
<br>
>> Secret within the meaning of the Act of 16 April 1993 on combating unfair
<br>
>> competition. If you received this message by mistake, contact the sender of
<br>
>> the message immediately and delete its content
<br>
>>
<br>
>> *From:* QGIS-User <qgis-user-bounces@lists.osgeo.org> *On Behalf Of *?rni
<br>
>> Geirsson via QGIS-User
<br>
>> *Sent:* Thursday, March 16, 2023 10:18 AM
<br>
>> *To:* jhubbslist@att.net
<br>
>> *Cc:* qgis-user@lists.osgeo.org
<br>
>> *Subject:* [EXTERNAL] Re: [Qgis-user] Geopackage slow on NAS if not
<br>
>> read-only
<br>
>>
<br>
>>
<br>
>>
<br>
>> UWAGA: Ta wiadomo?? pochodzi spoza CPK Sp. z o.o. Prosz? pom?? zadba? o
<br>
>> bezpiecze?stwo naszej organizacji. Zastan?w si?, zanim otworzysz link
<br>
>> lub za??cznik.
<br>
>>
<br>
>>
<br>
>>
<br>
>> Yes, as far as I know, the NAS unit uses SMB as the file sharing
<br>
>> protocol. I used another NAS from QNAP before this one, also using SMB and
<br>
>> with the same problem. I thought pretty much all of the Linux based NAS
<br>
>> units were using SMB and if that is the problem, it should be widespread,
<br>
>> but I don't see any signs of that. Is SMB a problem for geopackage?
<br>
>>
<br>
>> I did a quick test in QGIS: A dataset of 178.000 line features is
<br>
>> rendered in about 1 second from a read only geopackage. When I remove the
<br>
>> read only flag, it is rendered in about 5 seconds.
<br>
>>
<br>
>> If I store the geopackage on the local hard drive, the problem
<br>
>> disappears, read-write or read-only does not matter.
<br>
>>
<br>
>> I have had suspicions about SMB being part of the problem but I don't
<br>
>> know enough about file access deep down in the operating system to
<br>
>> understand it.
<br>
>>
<br>
>>
<br>
>>
<br>
>> ?rni Geirsson
<br>
>>
<br>
>>
<br>
>>
<br>
>>
<br>
>>
<br>
>>
<br>
>>
<br>
>> On Thu, 16 Mar 2023 at 01:45, jhubbslist--- via QGIS-User <
<br>
>> qgis-user@lists.osgeo.org> wrote:
<br>
>>
<br>
>> ?rni -
<br>
>>
<br>
>>
<br>
>>
<br>
>> Are you using SMB/CIFS to access this NAS, and are you using wifi or
<br>
>> Ethernet to connect to it?
<br>
>>
<br>
>>
<br>
>>
<br>
>> - Jeff
<br>
>>
<br>
>>
<br>
>>
<br>
>> On 3/15/23 3:30 PM, ?rni Geirsson via QGIS-User wrote:
<br>
>>
<br>
>> Hello all QGIS and geopackage users.
<br>
>>
<br>
>> I store my geopackages on a Synology RackStation NAS unit, like all other
<br>
>> documents that are kept on a shared drive in the office. For larger
<br>
>> datasets, the rendering is very slow, unless I open the properties dialog
<br>
>> for the file in Windows and check the read only box. After that, the
<br>
>> features are rendered blazingly fast. Nothing else is changed to see the
<br>
>> dramatic difference in the rendering speed. Luckily, I don't need to edit
<br>
>> many of the larger datasets, such as road networks and elevation contours
<br>
>> and the geopackage can be kept read only. Shapefiles are not affected.
<br>
>>
<br>
>> What explains this and does anyone know how to solve the problem?
<br>
>>
<br>
>> Do other users experience this?
<br>
>>
<br>
>>
<br>
>>
<br>
>> ?rni Geirsson
<br>
>>
<br>
>>
<br>
>>
<br>
>> _______________________________________________
<br>
>>
<br>
>> QGIS-User mailing list
<br>
>>
<br>
>> QGIS-User@lists.osgeo.org
<br>
>>
<br>
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user <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>
<br>
>>
<br>
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user <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>
<br>
>>
<br>
>>
<br>
>>
<br>
>> _______________________________________________
<br>
>> QGIS-User mailing list
<br>
>> QGIS-User@lists.osgeo.org
<br>
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
>> <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>
<br>
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
>> <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>
<br>
>>
<br>
>>
<br>
> _______________________________________________
<br>
> QGIS-User mailing listQGIS-User@lists.osgeo.org
<br>
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
>
<br>
> --
<br>
> Jorge Gustavo Rocha
<br>
> Geomaster, LDA
<br>
> "Take the open source journey with us"
<br>
>
<br>
> VAT/NIF: PT 510 906 109
<br>
> Phone: +351 253 257 173 (landline)
<br>
> Mobile: +351 910 333 888 (cellular)
<br>
>
<br>
> Rua Afonso Palmeira, 31, 7 D
<br>
> 4715-278 Braga
<br>
> PORTUGAL
<br>
> GPS 41.54627, -8.40432
<br>
>
<br>
>
<br>
> _______________________________________________
<br>
> QGIS-User mailing list
<br>
> QGIS-User@lists.osgeo.org
<br>
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
>
<br>
-------------- next part --------------
<br>
An HTML attachment was scrubbed...
<br>
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230316/15d748de/attachment.htm>
<br>
-------------- next part --------------
<br>
A non-text attachment was scrubbed...
<br>
Name: transparency_ce4012c8-87e7-4198-a48f-d42a38680681.png
<br>
Type: image/png
<br>
Size: 2458 bytes
<br>
Desc: not available
<br>
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230316/15d748de/attachment.png>
<br>
<br>
------------------------------
<br>
<br>
Subject: Digest Footer
<br>
<br>
_______________________________________________
<br>
QGIS-User mailing list
<br>
QGIS-User@lists.osgeo.org
<br>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
<br>
<br>
<br>
------------------------------
<br>
<br>
End of QGIS-User Digest, Vol 205, Issue 28
<br>
******************************************
<br>
<br>
</p>
</blockquote></div><br></div>