[mapguide-users] Re: Server stopped responding...?

[Miller, Craig]

Are there indexes on the spatial data?
http://msdn.microsoft.com/en-us/library/bb964714.aspx

On Wed, Jan 20, 2010 at 5:44 PM, Jamo <adam.jamison at portbris.com.au> wrote:

>
> I've since removed some SQL features ....
>
> Maybe this will help ? this Layer ahs some 300 features .... not many...
> however it seems to be taking sometime for ir ro even feth the identities?
> is this the SQL query time?
>
> SQL Feature
> cadFREE
> Time ....
>
> Profiling LayerDefinition:
>
> Session:a78183b8-e844-102c-8000-005056855030_en_7F0000010AF20AF10AF0//37e1ec81-60a0-4e38-8182-647862dff2d4.LayerDefinition
> Identity fetching:00:08.047 (Could be query time ?)
> Runtime layer creation:00:08.968
> Scalerange [0 : 10001]:00:01.796
> Scalerange [10001 : 10000000]:00:01.187
> Rendering scales:00:12.625 (Total Time taken to render cadFREE)
>
>
> Another example this is a shape file with few features .... seems to be a
> massive tiem difference though.
>
> SHP Feature
> EnvMBMPDA
> Profiling LayerDefinition:
>
> Session:a78183b8-e844-102c-8000-005056855030_en_7F0000010AF20AF10AF0//fe1f4327-ba13-44bb-9a56-e78495c2b12a.LayerDefinition
> Identity fetching:00:00.499
> Runtime layer creation:00:00.967
> Scalerange [0 : 10000000]:00:00.982
> Rendering scales:00:05.381
>
>
>
> I'm trying to put together some examples of how slow our SQL DB is
> performing when compared to other sources.
> However before I bug our IT section with this I need to be sure it's not
> some setting I can change in mapguide.
> I've been using the SQL server to show these features for over 2 months and
> haven't had any issues. rough 3-4secs to generate image on screen. I can't
> think of any changes I've made to effect this.
>
>
>
> --
> View this message in context:
> http://n2.nabble.com/Server-stopped-responding-tp4418346p4431060.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Craig Miller
Geospatial Software Architect
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100120/ca1571e1/attachment.html