<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:"Calibri Light";
panose-1:2 15 3 2 2 2 4 3 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.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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"><a name="_MailEndCompose">It SHOULD be significantly faster. We don’t have enough information to figure out why. You will need to check SQL indexes, server performance, network performance, etc…<o:p></o:p></a></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><b><i><span style="font-size:12.0pt;font-family:"Calibri Light",sans-serif;color:#2376BC">Martin Morrison</span></i></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:black">
<br>
</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:#404040">Infrastructure Application Engineer/Systems Analyst</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:black"><br>
</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><i><span style="font-family:"Calibri Light",sans-serif;color:#3172C4"> </span></i></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:#404040">Engineering
Design Systems, Inc</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:#2376BC">.</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:black"><br>
</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:#404040">540.345.1410</span></b></span><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:black"><br>
</span></b></span><span style="mso-bookmark:_MailEndCompose"></span><a href="mailto:martin.morrison@edsi.com"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-family:"Calibri Light",sans-serif;color:#0563C1">martin.morrison@edsi.com</span></b></span><span style="mso-bookmark:_MailEndCompose"></span></a><span style="mso-bookmark:_MailEndCompose"><span style="color:black"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><img border="0" width="192" height="87" style="width:2.0in;height:.9027in" id="Picture_x0020_1" src="cid:image001.jpg@01D40D57.A2D15290" alt="cid:image001.jpg@01D2249F.40681A50"></span></span><span style="mso-bookmark:_MailEndCompose"><span style="color:black"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><o:p> </o:p></span></p>
<span style="mso-bookmark:_MailEndCompose"></span>
<p class="MsoNormal"><b>From:</b> fdo-users [mailto:fdo-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Elad Lavi<br>
<b>Sent:</b> Tuesday, June 26, 2018 11:48 AM<br>
<b>To:</b> fdo-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [fdo-users] Can't select features using SQL Server data connection<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Thanks! that was it. I appreciate it.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Can someone advise me about a reason why when using SQL Server as a data connection, it is significantly slower than when working directly with the shape files?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">This is SQL Server 2014 Express. I imported the data from shape files to the database using shape2sql (which sadly didn't offer to add primary key).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Perhaps this is normal but I suspect that there's something I am missing with the FDO settings.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">The database is on the same machine of course.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks a lot.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Jun 26, 2018 at 3:53 PM Martin Morrison <<a href="mailto:martin.morrison@edsi.com">martin.morrison@edsi.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal">Do you have a primary key set?<br>
<br>
Martin Morrison <br>
Infrastructure Application Engineer/Systems Analyst<br>
Engineering Design Systems, Inc.<br>
540.345.1410<br>
<a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a><br>
<br>
<br>
-----Original Message-----<br>
From: fdo-users [mailto:<a href="mailto:fdo-users-bounces@lists.osgeo.org" target="_blank">fdo-users-bounces@lists.osgeo.org</a>] On Behalf Of Elad<br>
Sent: Tuesday, June 26, 2018 3:16 AM<br>
To: <a href="mailto:fdo-users@lists.osgeo.org" target="_blank">fdo-users@lists.osgeo.org</a><br>
Subject: [fdo-users] Can't select features using SQL Server data connection<br>
<br>
Hi. I'm new to MapGuide and Maestro but I am expirienced programmer.<br>
I have shape files and I have also imported them into MS SQL Server using shape2sql.<br>
When I create a data connection directly to the shape files, and then create a layer for some feature, I am able to select features using the select tool on the map.<br>
But, when I create the same layer using the SQL Server spatial feature source, the features are shown but are not selectable. When trying to select, it looks like it is processing (the red rectangle hangs for a while on the screen) but after few seconds, it
says "0 features selected" and the features are not highlighted as using the shape file directly.<br>
<br>
What I've tried so far: I susspected that when using the shape files directly, Maestro recognized the other files such as the .prj files with the coordinate system so in the data connection, I have set the coordinate system manualy to what ever it is in the
prj file. It didn't help.<br>
<br>
I have other issues such as slowness compared to working with the shape files directly.<br>
I realize the shape2sql is outdated and perhaps misimported the data into the database, but it does show correctly on the map with all the other feature data.<br>
<br>
Interstingly, when I set the tooltip to "TYPE" for example which is one of the feature data fields, it is shown! I can't select features even using the single feature selection.<br>
<br>
<br>
Please help.<br>
by the way, is there a forum for newbies?<br>
<br>
Thanks.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/FDO-Users-f3898664.html" target="_blank">
http://osgeo-org.1560.x6.nabble.com/FDO-Users-f3898664.html</a><br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org" target="_blank">fdo-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/fdo-users</a><br>
_______________________________________________<br>
fdo-users mailing list<br>
<a href="mailto:fdo-users@lists.osgeo.org" target="_blank">fdo-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/fdo-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/fdo-users</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</body>
</html>