[mapserver-users] logging GDAL queries

[Sebastian E. Ovide]

Hi Ivan,



> Because of that, to access your GeoRaster object, the GDAL driver is
> requesting a very large array of BLOB (1000000 approximately). T


I do not know how <apServer/GDAL works, but I cannot understand this query:


[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM
RDT_FLUVD04Q200PJ
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE  RASTERID = :1
AND
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]        PYRAMIDLEVEL =
:3
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]        BANDBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]        ROWBLOCKNUMBER
ASC,
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
COLUMNBLOCKNUMBER ASC

It looks like  MapServer/GDAL is trying to read the whole pyramid level X of
the table RDT_FLUVD04Q200PJ ?

Am I right ?

at level 0 it would read the whole raster !!!!

I was expecting to find in the logs some query that reads a subset of the
whole image (just the tile/metatile that MapServer is serving) for example
using SDO_GEOR.getRasterSubset..

any ideas ?

thanks
-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100814/21ce0141/attachment.htm>