Sumit, <br><br>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:
<pre class="oac_no_warn">r(n) = (int)(r(0) / 2^n)<br>c(n) = (int)(c(0) / 2^n)<br></pre><br><br>there are strange queries been executed.... <br><br>for example, at ANY zoom level I can see this one: (see level 3 !)<br><br>
[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.<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:<br>
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM RDT_FLUVD04Q200PJ<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE RASTERID = :1 AND<br>
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PYRAMIDLEVEL = :3<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] BANDBLOCKNUMBER ASC,<br>
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ROWBLOCKNUMBER ASC,<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] COLUMNBLOCKNUMBER ASC<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]<br>
[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.<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PL/SQL:<br>
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] SELECT RASTERBLOCK<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] FROM RDT_FLUVD04Q200PJ<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] WHERE RASTERID = :1 AND<br>
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] PYRAMIDLEVEL = :3<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ORDER BY<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] BANDBLOCKNUMBER ASC,<br>
[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] ROWBLOCKNUMBER ASC,<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40] COLUMNBLOCKNUMBER ASC<br>[Fri Aug 13 13:53:00 2010] [error] [client 10.0.1.40]<br>
<br><br>why ?<br><br><br><div class="gmail_quote">On Fri, Aug 13, 2010 at 12:56 PM, Sumit Sharma <span dir="ltr"><<a href="mailto:sumit321@hotmail.com">sumit321@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
I think there are 11 pyramid levels. could that be a problem? I am not an<br>
expert in GeoRaster, is it possible to create internal tiles in GeoRaster?<br>
if yes then, it may help you enhancing the performance<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/logging-GDAL-queries-tp5419225p5419742.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/logging-GDAL-queries-tp5419225p5419742.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
</font><div class="im">_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
</div><div><div></div><div class="h5"><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br><br>