OracleSpatial 10i GetExtent slow

[Fernando Simon]

Hi,
    The getExtent feature need to return the extent for the layer, 
and it's use as source the DATA definition.
    Of coure that for direct tables the USER_SDO_GEOM_METADATA is the
best way to retrieve the extent for the layer, but the getExtent
function needs to be generic. So if the user defined a DATA parameter
that use a function (like SDO_BUFFER, SDO_XOR), or a specific where,
the getExtent needs to work too.
    To work with all cases the maporaclespatial.c need to be generic.
In this moment the maporaclespatial.c don't use the
USER_SDO_GEOM_METADATA. You can try to define others parameters for
VERSION to test the results.
    Best regrads.

--------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
Laboratorio de Computacao Aplicada
UNIVALI/CTTMAR - Brazil
--------------------------------------------------

Citando Hallgren Johan E <jhhal at WMDATA.COM>:

> I have a table with about a million polygon records. 
> 
>  
> 
> When I will do a getExtent it takes looong time. Five to ten
> minutes. I
> can see it uses the "SELECT SDO_AGGR_MBR(SHAPE) AS GEOM FROM
> (SELECT
> SHAPE FROM SJ_large_sdo);" and it seams as it have to run a full
> table
> scan.
> 
>  
> 
> I'm using mapserver-4.8.1
> 
> Oracle 10.1 (windows Server)
> 
>  
> 
> MapFile:
> 
> CONNECTION "wmgis/xxx at wmsi1394"
> 
> CONNECTIONTYPE oraclespatial 
> 
> DATA "shape FROM (SELECT OBJECTID, SHAPE, KKOD FROM SJ_large_sdo)
> USING
> UNIQUE OBJECTID VERSION 10g" 
> 
>  
> 
> Is there a way to get the extent faster? Don't OracleSpatial have
> some
> metadata with extent?
> 
>  
> 
> Could I store the extent for the layer in the MapFile?
> 
>  
> 
> I'm using MapScript to build the logics
> 
>  
> 
> Thanks in advance
> 
> /Johan
> 
> ___________________________________
> 
> 
> Johan Hallgren
> WM-data
> 
> 
> Pelle Bergs backe 3
> Box 1938, 791 19 Falun
> Tel: 023-844 65 (int: +46-2384465)
> Mobil: 070-588 44 28 (int: +46-705884428)
> johan.e.hallgren at wmdata.com
> <BLOCKED::mailto:johan.e.hallgren at wmdata.com> 
> http://www.wmdata.se <BLOCKED::http://www.wmdata.se> 
> 
>  
> 
> 




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br