[TinyOWS-users] TinyOWS performance problem
olivier.courtin at gmail.com
Sun Jul 17 11:11:33 EST 2011
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
> 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
More information about the TinyOWS-users