[TinyOWS-users] Speed of GetFeature Request with 4 millions point

Olivier Courtin olivier.courtin at gmail.com
Thu Aug 18 15:08:42 EST 2011

On Thu, Aug 18, 2011 at 9:30 PM, Marc-André Trottier
<marcandre_trottier at hotmail.com> wrote:
> there is the diff with rc4.


> i switched all the WHERE clause for a INNER JOIN ON INTERSECT.

Why not, but is there a real advantage to do that ?

> i do the transformation on the POLYGON and not the geometry of the table.
> the request does one transformation on the polygon and not many
> transformation as the WHERE clause.

Well that was the precedent behaviour, but it cause problem
on PostgreSQL optimization plan (reported by Boris Leukert quite recently)


More information about the TinyOWS-users mailing list