<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:908416308;
mso-list-type:hybrid;
mso-list-template-ids:1417300306 68812815 68812825 68812827 68812815 68812825 68812827 68812815 68812825 68812827;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Good to hear.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>Martin Morrison<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Application Engineer<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Engineering Design Systems, Inc.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>3780 Peters Creek Rd Ext SW<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Roanoke, VA 24018<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>540.345.1410<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>gis.edsi.com<o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Ivan Milicevic<br><b>Sent:</b> Monday, July 18, 2011 1:10 AM<br><b>To:</b> MapGuide Users Mail List<br><b>Subject:</b> [mapguide-users] RE: MG and MSSQL performance<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=HR style='color:#1F497D'>Hello Martin,</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span lang=HR style='color:#1F497D'> </span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span lang=HR style='color:#1F497D'>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.</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span lang=HR style='color:#1F497D'> </span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span lang=HR style='color:#1F497D'>Thank you, you saved me a lot of researching hours.</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span lang=HR style='color:#1F497D'> </span><span lang=HR><o:p></o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Martin Morrison<br><b>Sent:</b> Friday, July 15, 2011 2:27 PM<br><b>To:</b> MapGuide Users Mail List<br><b>Subject:</b> [mapguide-users] RE: MG and MSSQL performance</span><span lang=HR><o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=HR> <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>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).</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> </span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>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.</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'> </span><span lang=HR><o:p></o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>Martin Morrison</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Application Engineer</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Engineering Design Systems, Inc.</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>3780 Peters Creek Rd Ext SW</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Roanoke, VA 24018</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>540.345.1410</span><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>gis.edsi.com</span><span lang=HR><o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'> </span><span lang=HR><o:p></o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Ivan Milicevic<br><b>Sent:</b> Friday, July 15, 2011 1:38 AM<br><b>To:</b> MapGuide Users Mail List (mapguide-users@lists.osgeo.org)<br><b>Subject:</b> [mapguide-users] MG and MSSQL performance</span><span lang=HR><o:p></o:p></span></p></div></div><p class=MsoNormal> <span lang=HR><o:p></o:p></span></p><p class=MsoNormal>Hello users,<span lang=HR><o:p></o:p></span></p><p class=MsoNormal> <span lang=HR><o:p></o:p></span></p><p class=MsoNormal>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<span lang=HR><o:p></o:p></span></p><p class=MsoNormal> <span lang=HR><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=HR><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]>To have or not to have FDO metadata in the database?<span lang=HR><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'>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<span lang=HR><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'> <span lang=HR><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=HR><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]>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)<span lang=HR><o:p></o:p></span></p><p class=MsoListParagraph> <span lang=HR><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=HR><span style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]>What is faster, fetching data from tables or views?<span lang=HR><o:p></o:p></span></p><p class=MsoListParagraph> <span lang=HR><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span lang=HR><span style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]>Where can I find a sample of FDO metadata tables?<span lang=HR><o:p></o:p></span></p><p class=MsoNormal> <span lang=HR><o:p></o:p></span></p><p class=MsoNormal>I hope so that answers are going to help a more than one Mapguide user.<span lang=HR><o:p></o:p></span></p><p class=MsoNormal> <span lang=HR><o:p></o:p></span></p><p class=MsoNormal>Thank you.<i><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:blue'> </span></u></i><span lang=HR><o:p></o:p></span></p><p class=MsoNormal><span lang=HR> <o:p></o:p></span></p></div></body></html>