[postgis-devel] [PostGIS] #497: [wktraster] Start testing displaying PostGIS raster with Mapserver

[PostGIS]

#497: [wktraster] Start testing displaying PostGIS raster with Mapserver
------------------------+---------------------------------------------------
  Reporter:  robe       |       Owner:  pracine        
      Type:  task       |      Status:  new            
  Priority:  medium     |   Milestone:  WKTRaster 0.1.6
 Component:  wktraster  |     Version:  trunk          
Resolution:             |    Keywords:                 
------------------------+---------------------------------------------------
Comment (by pracine):

 Please (if you have time???) try compare the performance of those three
 scenarios:

 1) Serving the raster directly from the filesystem (without storing them
 in PostGIS)

 2) Serving the raster when it is stored in WKT Raster (in-db)

 3) Serving the raster when it is only referenced by WKT Raster (out-db).
 This scenario implies: that the gdal wkt raster driver is able to
 recognize that the raster is stored out-db, and that it can then "morphe"
 itself into the right driver (raster could be stored as tiff in the
 filesystem). I would be amazed if it already does that... Further more if
 the raster is tiles, the gdal driver must be able to load all the
 necessary tiles as different rasters.

 Scenario 1) and 3) should have very similar performance.

 Scenario 2) should be slower but is very convenient as everything is
 stored in the DB.

 For sure a real scenario implies that the raster coverage is highly tiled.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/497#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.