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 <[email protected]> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Craig Miller Geospatial Software Architect
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
