Performance problems - ORACLE and OGR VRT?

Anderson Guiera Guiera at COPEL.COM
Wed Jul 18 05:48:32 PDT 2007


Hi list.

I'm using an ovf file to build an layer with oracle non-spatial data as
folow:

<OGRVRTDataSource>
        <OGRVRTLayer name="residuos">
        <SrcDataSource>ODBC:user/pass at odbcconnection</SrcDataSource>
        <SrcLayer>empresa_geradora_residuo</SrcLayer>
        <Fid>NUM_SEQ_EGR</Fid>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="coord_x_egr"
y="coord_y_egr"/>
        </OGRVRTLayer>
</OGRVRTDataSource>

in the map file i did this:

LAYER
       NAME "residuos"
       TYPE point
       CONNECTIONTYPE ogr
       CONNECTION "residuos/residuos.ovf"
       DATA "residuos"
       CLASS
            NAME "Residuos"
            STYLE
                 COLOR 0 128 128
            SYMBOL "Ponto4px"
            END #style
       END #class
       HEADER residuos_header.xml
       TEMPLATE residuos_template.xml
       FOOTER residuos_footer.xml
       TOLERANCE 3
       TOLERANCEUNITS pixels
END #layer

It's works but the response time is almost 40 seconds. In the database i
have almost 7600 records.

This performance is normal or not?
if isn't, what i must to do to improve this perform?
I'll appreciate your help.

Best regards,

Anderson J. Azambuja Guiera
Analista de Sistemas
COPEL - Companhia Paranaense de Energia S/A
DGC/STI/DGEP/VSGT
Tel: (55) 41 3331-3916    e-mail: guiera at copel.com



More information about the MapServer-users mailing list