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
