[mapguide-users] RE: MG and MSSQL performance

[Zac Spitzer]

from your earlier comment, do you have spatial indexes in place?

the execution plan was for a non spatial list 100 rows or a captured
mg generated query?

2011/7/18 Ivan Miličević <Ivan.Milicevic at supranet.hr>:
> 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
>
> _______________________________________________
> 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