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

[Jamo]

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.