[mapguide-users] RE: MG and MSSQL performance

[Ivan Miličević]

Ok, I had indexed views and on the server side execution was really fast (according to execution plan) but displaying and querying (read:selecting) features was slow.

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Monday, July 18, 2011 7:13 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] RE: MG and MSSQL performance

checkout indexed views, they are very useful for things like this

http://en.wikipedia.org/wiki/Materialized_view

z

2011/7/18 Ivan Miličević <Ivan.Milicevic at supranet.hr>:
> Hello Martin,
>
>
>
> I took your advice and resuslts are simply stunning. Still, I didn't 
> create indexes so the final result is going to be a massive improvement.
>
>
>
> Thank you, you saved me a lot of researching hours.
>
>
>
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Martin 
> Morrison
> Sent: Friday, July 15, 2011 2:27 PM
>
> To: MapGuide Users Mail List
> Subject: [mapguide-users] RE: MG and MSSQL performance
>
>
>
> Tables.  Setup a pre-canned table to match your views.  Either run a 
> nightly script or use triggers to populate it.  Make sure your table 
> is indexed properly (both search fields and spatial).
>
>
>
> Most end-users don't care about metadata.  They want to see a map and 
> get information (owner, address, etc.).  If all of your data is in the 
> same coordinate system, you can use the defaults.
>
>
>
> Martin Morrison
>
> Application Engineer
>
> Engineering Design Systems, Inc.
>
> 3780 Peters Creek Rd Ext SW
>
> Roanoke, VA  24018
>
> 540.345.1410
>
> gis.edsi.com
>
>
>
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Ivan 
> Milicevic
> Sent: Friday, July 15, 2011 1:38 AM
> To: MapGuide Users Mail List (mapguide-users at lists.osgeo.org)
> Subject: [mapguide-users] MG and MSSQL performance
>
>
>
> Hello users,
>
>
>
> I'm having some issues with MG performance when is fetching a data 
> from MS SQL 2008 R2 comes around. So, here are my questions about 
> impacts on performance
>
>
>
> 1.       To have or not to have FDO metadata in the database?
>
> For my project CS is not really important, so I keep everything in 
> local CS
> (XY-M) but I did not define anywhere (map definition, data source
> definition) cs. Everything is set to default
>
>
>
> 2.       I have lot's of views. One or two of them is really pain in 
> the ass. On the server side view execution plan is really fast but 
> when Mapguide interact with him (selecting features) it's really slow 
> (selecting is about
> 2sec)
>
>
>
> 3.       What is faster, fetching data from tables or views?
>
>
>
> 4.       Where can I find a sample of FDO metadata tables?
>
>
>
> I hope so that answers are going to help a more than one Mapguide user.
>
>
>
> Thank you.
>
>
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>



--
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users