[mapguide-users] using views

[Zac Spitzer]

tuning this such a query is very normal database tuning

there is a tuning advisor is the sql server tools and you can run an explain
plain to see what the database is doing.

the extremely basic rule of thumb is you should have indexes on the
joined columns

another thing to check, are the polygons very dense, like 5mm resolution?

BTW: if you are doing using a join in the database, the performance
issue has nothing
to do with mapguide, it's all about the db, the sql and your data

here is some useful info about tuning stintersects

http://go4answers.webhost4life.com/Example/slow-stintersects-108797.aspx

z



On Fri, Aug 3, 2012 at 6:35 AM, Jonathan Rizzo <jrizzo at langan.com> wrote:
> I will give that a try, although it will require a significant amount of work on the database (and related processes) to work around the limitations of schema bound views.  If that's the best way, then I suppose it has to be.  Thanks!
>
> Jon
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
> Sent: Thursday, August 02, 2012 11:19 AM
> To: mapguide-users at lists.osgeo.org
> Subject: Re: [mapguide-users] using views
>
> If you were using Oracle, I would suggest a "Materialized View", but SQL does not have this.
>
> Try this site to see how SQL handles this:
> http://blogs.msdn.com/b/ssma/archive/2011/06/20/migrating-oracle-materialized-view-to-sql-server.aspx
>
>
>
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/using-views-tp4992728p4992731.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> This electronic transmission may contain confidential, proprietary or privileged information. No confidentiality or privilege is intended to be waived or lost by erroneous transmission of this message. If you receive this message in error, please notify the sender immediately by return email and delete this message from your system. Disclosure, use, distribution or copying of this message, any attachments thereto or their contents is strictly prohibited.
> _______________________________________________
> 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