[postgis-users] mechanix of a query

[Pavel Iacovlev]

You can enable debug of Mapserver
http://mapserver.org/development/rfc/ms-rfc-28

You can configure PostgreSQL to log all your queries. Here is a tool
to analyze them and how to make PostgreSQL log them
http://pgfouine.projects.postgresql.org/tutorial.html

Mapserver computes the current bbox view and sends the query to
PostGIS and then you get all the geometries that are inside that bbox.
Thats why you should create a GisT index to speed things up.

On Sun, Sep 20, 2009 at 7:15 AM, P Kishor <punk.kish at gmail.com> wrote:
> I am trying to understand the mechanics of a getfeatureinfo query. My
> setup is data in Pg/PostGIS, served by MapServer via WMS, with
> OpenLayers in the front. When I click on a map and send a
> GetFeatureInfo query, MapServer grabs the x,y sent in the URL, and,
> for the layer (also sent in the URL), finds the row in the table which
> contains the x,y of my click.
>
> How does MapServer do that?
>
> Does it run a Pg/PostGIS query for this?
> How can I find out the syntax of this query?
>
> If a GetFeatureInfo takes too long, what can I do to speed it up?
>
>
> --
> Puneet Kishor
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
http://iap.md, The future is open