[mapserver-users] Investigating OpenLayers -> MapServer (WMS) -> OGR -> db

[Rob]

Or you could turn tracing on at the database side to see what SQL requests
it receives?  I'm only familiar with oracle, but you could do this in Oracle
using the 'alter system set sql_trace=true' command and checking the udump
directoty for logs.

On 18/04/2008, Christopher Schmidt <crschmidt at metacarta.com> wrote:
>
> On Fri, Apr 18, 2008 at 12:31:24PM -0500, P Kishor wrote:
> > SELECT wkt_geometry FROM <table> WHERE <extent of features is in the
> BBOX>
> >
> > That is what I want to investigate. What exactly is OGR/MapServer
> > executing? What is the form of "WHERE <extent of features in the
> > BBOX>"? How can I log this level of detail?
>
>
> You'll likely need to modify OGR to log this level of detail. In
> general, this type of logging is done by the 'server' in DB
> environments: Since SQLIte doesn't *have* a server, I don't think
> there's any way to do this external to OGR, and I don't believe that
> it's an existing feature of the OGR sqlite driver.
>
> In any case, MapServer is the wrong list for this: gdal-dev is probably
> the right place to go.
>
> Regards,
>
> --
> Christopher Schmidt
> MetaCarta
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080419/d33386d9/attachment.html