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

[Árni Geirsson]

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?
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.
If I store the geopackage on the local hard drive, the problem disappears,
read-write or read-only does not matter.
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.

Árni Geirsson



On Thu, 16 Mar 2023 at 01:45, jhubbslist--- via QGIS-User <
qgis-user at lists.osgeo.org> wrote:

> Árni -
>
> Are you using SMB/CIFS to access this NAS, and are you using wifi or
> Ethernet to connect to it?
>
> - Jeff
>
> On 3/15/23 3:30 PM, Árni Geirsson via QGIS-User wrote:
>
> Hello all QGIS and geopackage users.
> 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.
> What explains this and does anyone know how to solve the problem?
> Do other users experience this?
>
> Árni Geirsson
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230316/e1b6965a/attachment-0001.htm>