[TinyOWS-users] TinyOWS performance problem

[Olivier Courtin]

On Thu, Jun 9, 2011 at 6:40 PM, Leukert, Boris
<boris.leukert at wald-und-holz.nrw.de> wrote:
> I have found a workaround for the performance problem.
> The trick is to create a function based index on the
> table:
>
> CREATE INDEX parcels_digitized_the_geom_gist_trans
>  ON parcels_digitized
>  USING gist
>  (st_transform(the_geom, 31700));
>
> Now the query runs in 12ms with 6.3 million rows!

Could you try with r577 ?
I've rewrite the whole things

-- 
Olivier