Hi, I have all my geographic dates in oracle spatial 9i with SRID=82337 (UTM
ED-50). Can I configure my layers in Geoserver forms with epsg:23030 (UTM
ED-50)?. When I make WFS&WMS queries, is correct select SRS=23030 ???. I
want to use Geoserver to access the data via WMS&WFS. How much faster is
access throw Oracle(OCI) instead of Oracle???
Thanks in advanced:
F.Zuriaga
Fernando Zuriaga ha scritto:
Hi, I have all my geographic dates in oracle spatial 9i with SRID=82337 (UTM
ED-50). Can I configure my layers in Geoserver forms with epsg:23030 (UTM
ED-50)?. When I make WFS&WMS queries, is correct select SRS=23030 ???.
It should be correct, since the Oracle datastore does disregard the CRS you specify in queries and use the internal one (the one declared in the geometric columns). Just make sure the CRS you declared in geoserver form and the one you use for queries do match.
I want to use Geoserver to access the data via WMS&WFS. How much faster is
access throw Oracle(OCI) instead of Oracle???
I have no idea. I've noticed the Oracle datastore is slow, but it's unfortunately unmantained at the moment... if you come up with clues as to how improve performance, they would be appreciated.
Cheers
Andrea
On Wed, December 20, 2006 3:31 am, Fernando Zuriaga wrote:
Hi, I have all my geographic dates in oracle spatial 9i with SRID=82337
(UTM
ED-50). Can I configure my layers in Geoserver forms with epsg:23030 (UTM
ED-50)?. When I make WFS&WMS queries, is correct select SRS=23030 ???.
I believe so. Oracle can be weird sometimes. But yes, I think you pick
the EPSG code, not the oracle srid...
I
want to use Geoserver to access the data via WMS&WFS. How much faster is
access throw Oracle(OCI) instead of Oracle???
From what I've heard the Oracle OCI is substantially faster. But I'm not
sure if anyone's done real testing - it may be that the speed increases
with it aren't noticed in GeoServer because of other bottle necks. Though
Andrea recently did some bug fixes that should get Oracle even faster, so
when those get in it's more likely that OCI will get you some performance
improvements.
Thanks in advanced:
F.Zuriaga
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your opinions on IT & business topics through brief surveys - and earn
cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:1003,4588f519117171194215290!