Doug Newcomb-2 wrote > Hi Folks, > I was in a meeting today and the question came up: > What is the maximum size of a vector data layer in a geopackage database? > a > raster layer? > I did not see the answer in the few minutes of searching the internet, so > thought I would ask here. > > Doug
Hi, The limitations of SQLite itself apply https://www.sqlite.org/limits.html so you can't go over 140 terabytes. Practical limits depend on how you use GeoPackage. Some operations like VACUUM or, perhaps surprisingly, renaming a column of a table require re-writing of the whole database which is slow. If you insert and delete data and tables frequently it is good to vacuum it every now and then and keep the database rather small, let's say under 10 GB. If the usage is mostly read-only then I think that how you are going to deliver data for the users sets the limits, not the format. Even 10 GB can be rather expensive for mobile users. -Jukka Rahkonen- -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
