<div>Are there indexes on the spatial data?</div>
<div><a href="http://msdn.microsoft.com/en-us/library/bb964714.aspx">http://msdn.microsoft.com/en-us/library/bb964714.aspx</a><br><br></div>
<div class="gmail_quote">On Wed, Jan 20, 2010 at 5:44 PM, Jamo <span dir="ltr"><<a href="mailto:adam.jamison@portbris.com.au">adam.jamison@portbris.com.au</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><br>I've since removed some SQL features ....<br><br>Maybe this will help ? this Layer ahs some 300 features .... not many...<br>
however it seems to be taking sometime for ir ro even feth the identities?<br>is this the SQL query time?<br><br>SQL Feature<br>cadFREE<br>Time ....<br><br>Profiling LayerDefinition:<br>Session:a78183b8-e844-102c-8000-005056855030_en_7F0000010AF20AF10AF0//37e1ec81-60a0-4e38-8182-647862dff2d4.LayerDefinition<br>
Identity fetching:00:08.047 (Could be query time ?)<br>Runtime layer creation:00:08.968<br>Scalerange [0 : 10001]:00:01.796<br>Scalerange [10001 : 10000000]:00:01.187<br>Rendering scales:00:12.625 (Total Time taken to render cadFREE)<br>
<br><br>Another example this is a shape file with few features .... seems to be a<br>massive tiem difference though.<br><br>SHP Feature<br>EnvMBMPDA<br>Profiling LayerDefinition:<br>Session:a78183b8-e844-102c-8000-005056855030_en_7F0000010AF20AF10AF0//fe1f4327-ba13-44bb-9a56-e78495c2b12a.LayerDefinition<br>
Identity fetching:00:00.499<br>Runtime layer creation:00:00.967<br>Scalerange [0 : 10000000]:00:00.982<br>Rendering scales:00:05.381<br><br><br><br>I'm trying to put together some examples of how slow our SQL DB is<br>
performing when compared to other sources.<br>However before I bug our IT section with this I need to be sure it's not<br>some setting I can change in mapguide.<br>I've been using the SQL server to show these features for over 2 months and<br>
haven't had any issues. rough 3-4secs to generate image on screen. I can't<br>think of any changes I've made to effect this.<br><font color="#888888"><br><br><br>--<br>View this message in context: <a href="http://n2.nabble.com/Server-stopped-responding-tp4418346p4431060.html" target="_blank">http://n2.nabble.com/Server-stopped-responding-tp4418346p4431060.html</a><br>
Sent from the MapGuide Users mailing list archive at Nabble.com.<br>_______________________________________________<br>mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br></font></blockquote></div><br><br clear="all"><br>-- <br>Craig Miller<br>Geospatial Software Architect<br>