On Mon, May 7, 2012 at 9:43 PM, Paul Meems <[email protected]> wrote:
> This is working great, but is does take a very long time: about 7-10 seconds.
>
> The result are just a few features: 3-10
>
> Of course I have an index in the database on _adresid and a spatial index.
>
> What else can I do to speed up this filter?
>
run ANALYZE on the database (or just the table in question) and if that is
not enough disable prepared statements in the store configuration
Cheers
Andrea
--
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
