[Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only

[Johannes Kröger (WhereGroup)]

Since your problem seems to vanish if your files are read-only: Are you 
using a modern QGIS and GDAL? And were your GeoPackages created by that 
combination? Older versions (and apparently GPKGs created by older 
versions) used some kind of write-access to any opened GPKG, even if you 
weren't editing, and iirc a timestamp was updated. This might lead to 
extra network calls to your share, maybe even re-uploading the whole 
file all the time and miiiight be the issue here. With modern QGIS+GDAL 
opening GPKGs without editing should not do that anymore.

See https://github.com/qgis/QGIS/issues/23991

Maybe sniff your network traffic to check what really is going on.

Cheers, Hannes

Am 20.03.23 um 09:59 schrieb Árni Geirsson via QGIS-User:
> Thank you all who have responded over the weekend with helpful 
> suggestions. I wish I could use Linux on all the office computers but 
> that is not realistic. But what I have now learned is that a) I could 
> try NFS on Windows and b) there might be some hope in tweaking Samba. 
> Both are interesting threads to pursue.
> If it is true that the problem with geopackages/sqlite that I raised 
> in the beginning does not exist when shared under NFS, I have to 
> conclude that there is some bad chemistry between Samba and sqlite. 
> Maybe that is something the sqlite developers can resolve.
>
> Árni
>
>
> On Sat, 18 Mar 2023 at 21:07, David Strip via QGIS-User 
> <qgis-user at lists.osgeo.org> wrote:
>
>     On 3/18/2023 1:50 PM, Patrick Dunford via QGIS-User wrote:
>>     but I use NFS, which is not available on Windows (my computers
>>     run Linux)
>
>     NFS is available on Win 10 and 11 in the Pro and Enterprise
>     versions, but not the Home version.
>     I think it is not on by default, however.
>     _______________________________________________
>     QGIS-User mailing list
>     QGIS-User at lists.osgeo.org
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Johannes Kröger / GIS-Entwickler/-Berater

**********************************************
FOSSGIS Konferenz
15.-18. März 2023 in Berlin
https://fossgis-konferenz.de/2023/

WhereGroup-Beiträge auf der FOSSGIS
https://wheregroup.com/unternehmen/aktuelles/
**********************************************

WhereGroup GmbH
c/o KK03 GmbH
Lange Reihe 29
20099 Hamburg
Germany

Tel: +49 (0)228 / 90 90 38 - 36
Fax: +49 (0)228 / 90 90 38 - 11

johannes.kroeger at wheregroup.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230320/30f97f48/attachment.htm>