On Mon, May 7, 2012 at 10:09 PM, Paul Meems <[email protected]> wrote:
> 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?
>
Hum... enable the "geotools developer logging" and see what SQL is being run
in the logs.
Also look in the browser and check what actual request is run, maybe there
is some reprojection going without all the necessary CRS specs and GeoSever
ends up making a 100 degrees large request (instead of 100 meters wide).
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
