<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hi,<div>I also used txt files to load LiDAR points in QGIS because .shp was not good. This was before .gpkg came along, before I learned Python or CloudCompare. I am just starting to familiarize myself with the geopackage format so i am no .gpkg expert but this is what I would do or ask myself:</div><div><br></div><div>How are the files stored? Server, USB stick, hard-drive, SSD? </div><div><br></div><div>Are the files in the same CRS as the project? If not, every thing may be read in cache and reprojected even before you start...</div><div><br></div><div>What happens when the files are simplified? Try more files and less layer, try more points in the same files. Try a fresh project an open the layers one by one. Is one more problematic than others? Enough memory? Disable all plugins.</div><div><br></div><div>Caching features: in your QGIS options, you can change the amount of featured that are cashed when you open a lector layer. Try cashing more feature or much less features (like 1). What happens? If you have a max of 16000 features per layer, chances are you are caching everything so everything is being loaded to memory.</div><div><br></div><div>File creation: how are the files created? Look at the options in Gdal if the files are created in QGIS. <a href="https://gdal.orgdrivers/vector/gpkg.html">https://gdal.orgdrivers/vector/gpkg.html</a> Try creating the files with Gdal translate (vector menu) instead of just “export as” or save as in QGIS, force extra option to force index creation.</div><div><br></div><div>Do you have a spatial index build in? In theory .gpkg comes with a spatial index but perhaps you can rebuild one? Or make sure you build on from the start when you create the file. (See above).</div><div><br></div><div>I remember that when I created a .gpkg in python, and used it in ArcGis, the file would take a long time to open because it was reading every point of the file in order just to get the files extent. Maybe that is going on? I think you can specify the files extent in the file metadata. (I would need to check my code but I don’t see my solution here. I normally post them whenI find them...).<a href="https://gis.stackexchange.com/questions/374408/using-geopandas-generated-gpkg-in-arcmap"> https://gis.stackexchange.com/questions/374408/using-geopandas-generated-gpkg-in-arcmap</a> </div><div><br></div><div>Just a bunch of ideas...</div><div><br><div dir="ltr">Nicolas Cadieux<div><a href="https://gitlab.com/njacadieux">https://gitlab.com/njacadieux</a></div></div><div dir="ltr"><br><blockquote type="cite">Le 10 déc. 2020 à 09:41, Francesco Pelullo <f.pelullo@gmail.com> a écrit :<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="auto">Hi all,<div dir="auto"><br></div><div dir="auto">I'm running QGIS 3.10 LTR on Windows 10.</div><div dir="auto"><br></div><div dir="auto">My project has 6 .gpkg files connected, everyone of these has 14 layers with points geometries, every layer counts about 16.000 features.</div><div dir="auto"><br></div><div dir="auto">So my QGIS project manage about 1.344.000 points, not used at same time.</div><div dir="auto"><br></div><div dir="auto">When i open this project, QGIS needs about 15 minutes for go ready.</div><div dir="auto"><br></div><div dir="auto">Instead, if i store these points in separate .TXT files, QGIS needs only few seconds for load layers and go ready. Also .shp layer format seems more performant than .gpkg</div><div dir="auto"><br></div><div dir="auto">It seems to me that they are not really efficient for these points layers.</div><div dir="auto"><br></div><div dir="auto">Is this a my problem? Or there are some tricks i could use? </div><div dir="auto"><br></div><div dir="auto">.gpkg are vacuumed regularly.</div><div dir="auto"><br></div><div dir="auto">Best regards </div><div dir="auto"><br></div><div dir="auto">Francesco</div><div dir="auto"><br></div><div dir="auto"><br></div></div>
<span>_______________________________________________</span><br><span>Qgis-user mailing list</span><br><span>Qgis-user@lists.osgeo.org</span><br><span>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br><span>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</span><br></div></blockquote></div></body></html>