[mapguide-users] RE: MG and MSSQL performance

[Zac Spitzer]

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