On Fri, Aug 17, 2012 at 7:21 PM, cheesybiscuits
<[email protected]>wrote:
> In a single WMS 1.1.1 request I am rendering 130,000 point features.
> Locations are stored in Oracle in WGS84 lat/lon with a default r-tree
> spatial index. Points are styled with the default point SLD (red square, no
> external graphic) and no filter criteria are applied in SQL other that an
> SDO_RELATE on the bbox. No projection occurs other than getting the
> lat/longs onto a 2D image. From looking at Oracle traces and
> GeoServer-GeoTools logs this is what I think happens:
>
Btw, in the case of Oracle we support only prepared statements when
connecting
to the database. A prepared statement works so that the query is sent to the
DBMS only once, with placeholders in the place of the parameters,
and a access plan is done not knowing what the param values are.
In the case of a bbox query the db will assume using the spatial index is
the
most efficient way, but in fact it's not, a sequential scan would be much
faster.
For postgis we allow the choice of using plain statements or prepared
statements,
the first always win in term of performance, by a few times in the case of
whole
dataset access (5 times in some tests I've made).
Having the double code path requires work though, work that was never
sponsored
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
