[UMN_MAPSERVER-USERS] oracle slowly than arcsde

[Ivano Picco]

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>>