> Yes, that makes gdalinfo fast. With my biggest layer the time went down > from 3 minutes to 3 seconds. However, my gdal_translate test fails. It > used to take three minutes before the zero appeared into the progress bar > but after that translation itself took only few seconds. After updating > to GDAL r24803 program shows the zero percent progress within couple of > seconds but unfortunately nothing happens in any reasonable time after > that.
Is the reasonable time more than 3 minutes ? > > >gdal_translate -of Gtiff -outsize 1% 1% RASTERLITE:test.sqlite,table=t0080 > >test.tif > > Input file size is 153600, 249600 > 0 > > Overviews are ok so taking the one percent downsampes should be fast. > Overviews: 76800x124800, 38400x62400, 19200x31200, 9600x15600, 4800x7800, > 2400x3900, 1200x1950, 600x975, 300x488 I've tested the gdal_translate -outsize 1% 1% with a 104740 x 49510 raster and it works fast for me. Could you add --debug on to the above gdal_translate and report what it outputs ? And also, to confirm that it is due to the changes in sqlite driver and not the ones in the rasterlite driver, you could retry but after having deleted the statistics : ogrinfo test.sqlite -sql "DELETE FROM layer_statistics" and then again gdal_translate --debug on [...] > > -Jukka- > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
