On Mon, Aug 20, 2012 at 10:45 AM, Andrea Aime
<[email protected]>wrote:
> Shapefile: 0.35s
> PostGIS with prepared statements: 4.5s
> PostGIS without prepared statements: 4.5s
> Oracle XE: 6.3s
>
Quick followup here. Applied David's fix for the fetch size, it helps:
XE, f.s. 1000: 4.9s
XE, f.s. 5000: 4.5s
So yeah, pumping up the fetch size seems to help (200 was too low for
Oracle)
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
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://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
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
