[gdal-dev] GDAL GeoPackage raster support

[Even Rouault]

Stefan,

> 
> I'm playing with the new Geopackage raster support which is really nice.
> Thanks for that. Some feedback so far:
> 
> * Loading in QGIS is instant when overviews are added with gdaladdo [1] but
> really slow when there are no  overviews [2].

As will other formats with a dataset of the same size I guess ?

> * Adding overviews to some areal images is really slow: gdaladdo only eats
> < 10 % of the cpu. Is this some slow storage medium issue (harddisk)?

In the update scenario like gdaladdo, an optimization that is used when 
creating the file from scratch (gdal_translate) isn't applied. You can try 
adding "--config OGR_SQLITE_SYNCHRONOUS OFF" on the gdaladdo command line. I 
suspect this must be the issue. I was a bit hesitant to apply it by default in 
update cases since it means that a interruption of the process (ctrl-c) could 
damage the database. But this is generally the case for other formats, so we 
probably could apply it too.

Even

> 
> [1]: http://catais.org/tmp/hoehen.gpkg
> [2]: http://catais.org/tmp/hoehen_ohne.gpkg
> 
> best regards
> Stefan
> 
> 
> 
> 
> On Thu, Dec 11, 2014 at 4:40 PM, Paolo Cavallini <cavallini at faunalia.it>
> 
> wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> > 
> > Hi Even,
> > 
> > Il 11/12/2014 16:37, Even Rouault ha scritto:
> > > I'm confused by your comment :
> > sorry I was unclear:
> > > - are you trying to load a raster geopackage through "load
> > > vector"... ? That will not do it. You should open it with "load
> > > raster". That works with my antique QGIS 1.8 linked against GDAL
> > > trunk ;-) - are you using GDAL trunk ? This is necessary for raster
> > > support. Vector support should mostly work with GDAL 1.11
> > 
> > I'm saying that QGIS cannot load .gpkg, therefore I cannot do more
> > tests. When fixed, I'm available for testing.
> > 
> > All the best.
> > 
> > - --
> > Paolo Cavallini - www.faunalia.eu
> > QGIS & PostGIS courses: http://www.faunalia.eu/training.html
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1
> > 
> > iEYEARECAAYFAlSJuvYACgkQ/NedwLUzIr5YrACgsVW3i48tsZqJTeFfA8iWPjhj
> > OXYAnRZWgxCAUZWm9qmstCyjbUOw7XMa
> > =qq+j
> > -----END PGP SIGNATURE-----
> > _______________________________________________
> > gdal-dev mailing list
> > gdal-dev at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com