Hi list!, I made some tests with mapserver using the same layer from Oracle Spatial (10G) and SDE (9.2) (ArcSDE on top of the same Oracle DBMS), it is a very simple layer: 1265 features, type polygon. My tests are simple concurrent WMS connections with same envelope to mapserver on an apache webserver with mod_fcgid to avoid problem related to Oracle memory leak and as a workaround for the cgi processes during ArcSDE connections. I report my results on the picture attached. As you can see Oracle connections are very slowly than ArcSDE. I saw the same behaviour with cgi on apache and lighttpd. What is the problem? Can i do anything to optimize it?
The web server has 2 Intel Xeon 3.40GHz and 2GB of RAM and Linux CentOS
4.5. The database server is a Sun-Fire-V210 with Solaris 9, it has 2 sparcv9
processor operates at 1002 MHz and
2GB of RAM.
Any help would be appreciate,
thanks,
Ivano
This is an extract from my mapfile:
LAYER
NAME "CTR-SDE"
STATUS ON
DEBUG ON
DATA "ctr_sde.comuni,SHAPE"
TYPE POLYGON
CONNECTIONTYPE SDE
CONNECTION "bubble,port:5153,esri_sde,ctr_sde,ctr_sde"
PROCESSING "CLOSE_CONNECTION=DEFER"
TEMPLATE "template.html"
METADATA
"WMS_SRS" "EPSG:32632"
"WMS_NAME" "Comuni_SDE"
"WMS_TITLE" "Comuni_SDE"
"WMS_ABSTRACT" "Comuni SDE"
END
CLASS
STYLE
OUTLINECOLOR 0 0 0
ANTIALIAS TRUE
END
END
END
LAYER
NAME "CTR-SDO"
STATUS ON
DEBUG ON
DATA "GEOMETRY FROM comuni USING UNIQUE OBJECTID SRID 82344 FILTER
VERSION 10G"
TYPE POLYGON
CONNECTIONTYPE oraclespatial
CONNECTION 'ctr_sdo/[EMAIL PROTECTED]:1522/OLYMPIA'
PROCESSING "CLOSE_CONNECTION=DEFER"
TEMPLATE "template.html"
METADATA
"WMS_SRS" "EPSG:32632"
"WMS_NAME" "Comuni_SDO"
"WMS_TITLE" "Comuni_SDO"
"WMS_ABSTRACT" "Comuni SDO"
END
CLASS
STYLE
OUTLINECOLOR 0 0 0
ANTIALIAS TRUE
END
END
END
<<Test_results.jpg>>
