<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello List,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I have a site which I created using SQL Server 2008 to store all of the data. The site works great, but one operation seems to be particularly slow. I created a view to join a polygon feature source with some other database data, and
I use that view to define my layer. This works, but is extremely slow. It can take anywhere from 2-9 seconds to query the layer, depending on server loadSQL Server is telling me that the offending query is just a SELECT statement which calls [geom].STIntersects
in the ‘WHERE’ clause (presumably to find all of the polygons within the extents of the map). . The table contains less than 1000 polygons, and the query should select less than 100 of them.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I KNOW that joins like this are a performance issue with MapGuide, but I was wondering if there are any “best practices” documented anywhere to improve performance to the maximum extent possible, such as how to define any indexes. Any
suggestions would be greatly appreciated.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Jon</p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""><br clear="all">
</span><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black">Jonathan Rizzo
</span></b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black"><br>
<b>Senior Applications Developer </b><br>
Direct: 201.398.4650<br>
Mobile: 551.206.5782 <br>
Fax: 201.398.4850 <br>
<br>
<b>Langan Engineering & Environmental Services</b> <br>
Phone: 201.794.6900 Fax: 201.794.0366 <br>
619 River Drive Center 1<br>
Elmwood Park, NJ 07407-1338 <br>
<a href="http://www.langan.com"><span style="color:blue">www.langan.com </span></a><br>
<br>
</span><b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:#006699">Langan’s goal is to be SAFE (Stay Accident Free Everyday)</span></b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black">
<br>
<br>
</span><b><span style="font-size:7.5pt; font-family:"Arial","sans-serif"; color:black">NEW JERSEY NEW YORK CONNECTICUT PENNSYLVANIA VIRGINIA FLORIDA CALIFORNIA
<br>
ABU DHABI ATHENS DOHA DUBAI ISTANBUL </span></b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black"><br>
<br>
</span><b><span style="font-size:7.5pt; font-family:"Arial","sans-serif"; color:#386D3E">Please consider the environment before printing this e-mail</span></b><span style="font-size:10.0pt; font-family:"Arial","sans-serif"; color:black">
</span></p>
</div>
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.
</body>
</html>