[TinyOWS-users] Speed of GetFeature Request with 4 millions point
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