Thanks Andrea,
I already had disabled 'Prepared Statements', it's the default value.
I ran ANALYZE on the table but that didn't improve the speed. Probably too
small to notice.
Do you have any other suggestions?
--
Paul
2012/5/7 Andrea Aime <[email protected]>
> 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
