<html>
<head>
</head>
<body>Hallo<br />
<br />
What you are doing with ST_Dwithin is to check if your geom and geometry have parts closer to (or exactly) 0.00001 mapunits from eachother. If you are using a meter based SRID then you are checking if they are within 0.00001 meters from eachother. So actually in this case your points can be just outside the polygon and returning true. If you want to use st_dwithin you should use 0 instead of 0.00001 . But I don't think that is any faster than ST_Intersects. The important thing in both cases is to have working spatial indexes. <br />
<br />
put an index on geom column in my_neighbour table and analyze the table.<br />
<br />
Create index idx_mn_geom <br />
on my_neighbour<br />
using gist(geom);<br />
analyse my_neighbour;<br />
<br />
Then try:<br />
SELECT id, geom<br />
FROM my_neighbour<br />
WHERE ST_Intersects (geom, geometry);<br />
<br />
I guess that is the best solution.<br />
<br />
Hope that helps<br />
<br />
Nicklas<br />
<br />
2010-05-25 nguyen liem wrote:<br />
<br />
Hi all<br />
><br />
>At the first time i used ST_Contains but it take a long time, so I used ST_Dwithin to improve the performance for the query statement but i don't know it is correct or not.<br />
>I would like to know my points are within in polygon or not:<br />
><br />
>SELECT id, geom<br />
>FROM my_neighbour<br />
>WHERE ST_Dwithin (geom, <span style="font-weight: bold;">geometry</span>, <span style="font-weight: bold;">0.00001</span>)<br />
><br />
><span style="font-weight: bold;">geometry:</span> is a polygon(input parameter).<br />
><span style="font-weight: bold;">0.00001:</span> I means the radius of <span style="font-weight: bold;">geometry</span> is 1 meters, is it right?<br />
><br />
><br />
>Cheers.<br />
><br />
>-- <br />
>Liem Nguyen<br />
>Developer<br />
>Axon Active Corp.<br />
>----------------------------------------------------------------------------<br />
>Direct Line : +84 38 948 4645<br />
>Fax : +84 38 811 3489<br />
>
Mobile Phone : +84 168 994 8897<br />
>Skype ID : liemnguyendl2204<br />
>Email : <a>liem.nguyen@axonactive.net</a> / <a>liemnguyendl@gmail.com</a><br />
>
Web Site : <a href="http://axonactive.vn" target="_blank">axonactive.vn</a><br />
>Address : 87 Thang Long Street,Gate 2 Ward 4,<br />
> Tan Binh District, HCM city, Vietnam.<br />
><br />
>
</body>
</html>