[gdal-dev] Maximum size of Raster and vector layers in geopackage database

[jratike80]

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