[mapguide-users] RE: MG and MSSQL performance

[Martin Morrison]

Good to hear.

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: Monday, July 18, 2011 1:10 AM
To: MapGuide Users Mail List
Subject: [mapguide-users] RE: MG and MSSQL performance

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20110719/a72a1ae7/attachment.html