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ć <[email protected]>: > 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: [email protected] > [mailto:[email protected]] 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: [email protected] > [mailto:[email protected]] On Behalf Of Ivan Milicevic > Sent: Friday, July 15, 2011 1:38 AM > To: MapGuide Users Mail List ([email protected]) > 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 > [email protected] > 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
