Thanks again Bart for all.<br><br>I added this parameter to all layers, and now works fine.<br><br><br><div><span class="gmail_quote">2007/1/9, Bart van den Eijnden (OSGIS) <<a href="mailto:bartvde@osgis.nl">bartvde@osgis.nl
</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Probably Oracle is calculating the boundingboxes/extents for all of your<br>
LAYERS, this is requested by Mapserver to produce the capabilities and is<br>very time consuming/costly.<br><br>Try setting the wms_extent METADATA for all of your LAYERs so that no<br>automatic calculation of the extents will be performed.
<br><br>Best regards,<br>Bart<br><br>--<br>Bart van den Eijnden<br>OSGIS, Open Source GIS<br><a href="http://www.osgis.nl">http://www.osgis.nl</a><br><br><br>--------- Oorspronkelijk bericht --------<br>Van: José Ramón López <
<a href="mailto:joseramonlopez@GMAIL.COM">joseramonlopez@GMAIL.COM</a>><br>Naar: <a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</a> <<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU
</a>><br>Onderwerp: [UMN_MAPSERVER-USERS] Slow map server doing getcapabilities with<br>200 layers<br>Datum: 09/01/07 10:03<br><br>> Hi dear list, again.We are trying to make a wms service with MapServer.<br>The number of layers is 180, wich are stored in Oracle. When we do a
<br>GetCapabilities request, it takes a lot of time sending the xml file. While<br>it is sending the file, something curious happens. The process that takes<br>the most of the memory of the computer is Oracle. Is there any parameter
<br>defined in the .map file, that makes the computer verify all the layers<br>stored in the .map file?<br>> When i do a getlayer like ...Request=GetMap&amp;Layers=xxx, it shows me<br>fast.Does Oracle verify the layers, when we do a getcapabilities request?How
<br>i could optimize this?Thanks for all<br>> -- José Ramón López<br>><br><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>José Ramón López<br><br>