[Mapserver-users] Mapserver - OGR - Oracle (revisited)

[Daniel Morissette]

bartvde at xs4all.nl wrote:
> 
> But now there is the following problem that a WMS GetCapabilities request
> takes more than one minute (also resulting in a full table scan in
> Oracle). Is there any way to prevent this, can it be read from the
> USER_SDO_GEOM_METADATA table or the MAP file?
> 

You can set the "wms_extent" layer metadata in the mapfile and this 
value will be used in priority. The value is "minx miny maxx maxy" in 
the same projection as the data.

If the wms_extent is not found then MapServer does its best to calculate 
the extents, depending on the format and its implementation in OGR that 
could be very quick, or very long as you noticed here.

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