<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>Marc-André ,</div>
<div><br>
</div>
<div>Try setting the ows_extent metadata parameter for the layer (you can make it world extents). MapServer, when it doesn't know the extents of a layer will issue a query to get those extents and it can be quite expensive for some layers. So you can populate
your metadata with the extents to avoid this lookup.</div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
<div>
<div>
<div>
<div>-- </div>
<div>Michael Smith</div>
</div>
<div>US Army Corps</div>
<div>Remote Sensing GIS/Center</div>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Marc-André Trottier <<a href="mailto:marcandre_trottier@hotmail.com">marcandre_trottier@hotmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Tue, 29 Nov 2011 18:05:46 -0500<br>
<span style="font-weight:bold">To: </span><<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>[mapserver-users] wfs request getfeature with polygon<br>
</div>
<div><br>
</div>
<p>! i'm doing a WFS GetFeature request with a polygon.<br>
Usually everything is fine. <br>
but for one table a got a enconding error with my data. (my problem) and the mapserver's log give me this SQL :</p>
<p>select "nom","adresse","postal","code","telephone","postal0","etab_code","etab_nom","rss_code","rss_nom","rls_code","rls_nom","clsc_code","clsc_nom","mun_code","mun_nom","longitude","latitude","sgs","hsld","clsc","pdi","pdp","pat","cj","sp","objectid","nom_commun",encode(ST_AsBinary(ST_Force_2D("geom_p"),'NDR'),'hex')
as geom,"objectid" from msss_v_sgs_p where geom_p && GeomFromText('POLYGON((-1100000 -23500,-1100000 2253500,1100000 2253500,1100000 -23500,-1100000 -23500))',find_srid('','msss_v_sgs_p','geom_p'))</p>
<p>So my question, Why is mapserver does a spatial query with the layer's extent?<br>
with a table of 2millions features, that,s very slow even with a spatial index</p>
<p>marc-andre trottier</p>
_______________________________________________ mapserver-users mailing list <a href="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">
http://lists.osgeo.org/mailman/listinfo/mapserver-users</a> </span>
</body>
</html>