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

[Árni Geirsson]

Thank you for the suggestion - I always use the latest versions and this
problem is certainly present in these.

Árni


On Mon, 20 Mar 2023 at 09:40, Johannes Kröger (WhereGroup) <
johannes.kroeger at wheregroup.com> wrote:

> 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 listQGIS-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 Berlinhttps://fossgis-konferenz.de/2023/
>
> WhereGroup-Beiträge auf der FOSSGIShttps://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.comwww.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/0d3d0b99/attachment.htm>