[mapserver-users] Re: logging GDAL queries

[Sebastian E. Ovide]

Sumit,

The size of the pyramid image at each level is determined by the original
image size and the pyramid level, according to the following formulas:

r(n) = (int)(r(0) / 2^n)
c(n) = (int)(c(0) / 2^n)



there are strange queries been executed....

for example, at ANY zoom level I can see this one: (see level 3 !)

[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] GDAL:
GDALOpen(georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1,
this=0x2986210) succeeds as GeoRaster.
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:
[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
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] GDAL:
GDALOpen(georaster:geoserver,geoserver,MFPRODUK_11G,fluvd04q200pj,georaster,id=1,
this=0x18be210) succeeds as GeoRaster.
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:
[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
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]


why ?


On Fri, Aug 13, 2010 at 12:56 PM, Sumit Sharma <sumit321 at hotmail.com> wrote:

>
> I think there are 11 pyramid levels. could that be a problem? I am not an
> expert in GeoRaster, is it possible to create internal tiles in GeoRaster?
> if yes then, it may help you enhancing the performance
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/logging-GDAL-queries-tp5419225p5419742.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>



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