How can I capture mg generated query? EP was for query thats is the same one when I select something from C# code (MGQuery.setilter()).
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Zac Spitzer Sent: Monday, July 18, 2011 7:30 AM To: MapGuide Users Mail List Subject: Re: [mapguide-users] RE: MG and MSSQL performance 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ć <[email protected]>: > 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: [email protected] > [mailto:[email protected]] 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ć <[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 > > _______________________________________________ > 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
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
