[gdal-dev] Gdaladdo feels slow with Rasterlite

[Rahkonen Jukka]

Even Rouault wrote:

>> One issue there is still.  My original was a highly compressed (deflate)
>> tiff with a file size of 550 MB.  Initial transform into Rasterlite with
>> png tiles yielded a 1.2 GB Rasterlite db. Condiderably bigger but still
>> understandable.  However, gdaladdo has no option to compress internal
>> overviews which make most sense with Rasterlite.

> Good point. Support for specifying options was actually missing. Added in
> trunk in r24660.

Feels pretty good but I have an odd problem with a multitable database.  I can only 
create overviews for the table that was written first into the database.

gdalinfo
=======
gdalinfo taustak.sqlite
Driver: Rasterlite/Rasterlite
Files:
Size is 512, 512
Coordinate System is `'
Subdatasets:
  SUBDATASET_1_NAME=RASTERLITE:taustak.sqlite,table=t0320
  SUBDATASET_1_DESC=RASTERLITE:taustak.sqlite,table=t0320
  SUBDATASET_2_NAME=RASTERLITE:taustak.sqlite,table=t0800
  SUBDATASET_2_DESC=RASTERLITE:taustak.sqlite,table=t0800
  SUBDATASET_3_NAME=RASTERLITE:taustak.sqlite,table=t2000
  SUBDATASET_3_DESC=RASTERLITE:taustak.sqlite,table=t2000
  SUBDATASET_4_NAME=RASTERLITE:taustak.sqlite,table=t4000
  SUBDATASET_4_DESC=RASTERLITE:taustak.sqlite,table=t4000
  SUBDATASET_5_NAME=RASTERLITE:taustak.sqlite,table=t8000
  SUBDATASET_5_DESC=RASTERLITE:taustak.sqlite,table=t8000

table t8000 OK
==========

gdaladdo RASTERLITE:taustak.sqlite,table=t8000 2 4 8 16 --config
 RASTERLITE_OVR_OPTIONS DRIVER=png
0...10...20...30...40...50...60...70...80...90...100 - done.
0...10...20...30...40...50...60...70...80...90...100 - done.

table t4000 not OK
============

F:\taustakartat>gdaladdo RASTERLITE:taustak.sqlite,table=t4000 2 4 8 16 --config
 RASTERLITE_OVR_OPTIONS DRIVER=png
ERROR 4: `RASTERLITE:taustak.sqlite,table=t4000' does not exist in the file system,
and is not recognised as a supported dataset name.

-Jukka-