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

[Olivier Courtin]

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

Thanks,

> 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)

-- 
Olivier