OracleSpatial 10i GetExtent slow

[Hallgren Johan E]

I hope you all understood that there still is a need for function that
retrieves the layerextent from metadata if it's available (as Frank
mentions). In my case we have over a million records in the table and to
calculate extent for the layer by go true all those records will take to
much time.

Best regards
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
http://www.wmdata.se

-----Original Message-----
From: UMN MapServer Developers List [mailto:MAPSERVER-DEV at LISTS.UMN.EDU]
On Behalf Of Daniel Morissette
Sent: den 24 februari 2006 21:18
To: MAPSERVER-DEV at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-DEV] OracleSpatial 10i GetExtent slow

Sean Gillies wrote:
> On Feb 24, 2006, at 8:12 AM, Frank Warmerdam wrote:
> 
>> Hallgren Johan E wrote:
>>
>>> Hello
>>>
>>> I have used the mapscript function getExtent for a layer, to get the
>>> extent, that one was slow. Do you mean that the msOWSGetLayerExtent
>>> would be faster?
>>>
>>> Could it be possible to change the logic so the function I need
would
>>> run the msOWSGetLayerExtent instead?
>>
>>
>> Johan / others,
>>
>> I'm no expert on this area of the code, but it definitely seems  like
we
>> ought to offer a mapscript mechanism that works like  
>> msOWSGetLayerExtent,
>> using layer metadata if available.
>>
>> In the meantime Johan, if you already know your extents (as you
would 
>> have
>> to for setting up OWS metadata on a layer) you could just modify your
>> mapscript application to hardcode the extent or perhaps to pull it  
>> manually
>> from layer metadata.
> 
> 
> Layers have an extent just like the map, so that's probably better
than 
> the metadata. layerObj.getExtent will preferentially return the
layer's 
> extent attribute, and then fall back on a query of the  datasource.
> 
> I can't say for sure if this is implemented for the PHP mapscript.
> 

Yes, PHP MapScript's $layer->getExtent() calls msLayerGetExtent() 
directly the same way as the SWIG equivalent.

Daniel
-- 
------------------------------------------------------------
  Daniel Morissette               dmorissette at dmsolutions.ca
  DM Solutions Group              http://www.dmsolutions.ca/
------------------------------------------------------------