Actually, I tried to indeks my views but I couldnt get rid of error message "Cannot create indeks on view "myView" because the view is not schema bound.
-----Original Message----- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] 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ć <ivan.milice...@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-boun...@lists.osgeo.org > [mailto:mapguide-users-boun...@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.milice...@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-boun...@lists.osgeo.org >> [mailto:mapguide-users-boun...@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-boun...@lists.osgeo.org >> [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Ivan >> Milicevic >> Sent: Friday, July 15, 2011 1:38 AM >> To: MapGuide Users Mail List (mapguide-users@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@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > mapguide-users mailing list > mapguide-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
