<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{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: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><span style='color:#1F497D'>Thanks for the details. That
makes it much easier to provide some insight in to the issues.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I suspect that depending on the
number of records involved in each of your joins, the joins are the likely
culprit causing performance problems.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Having the SDF files on another
server is also a big performance decrease.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>The SDF files should be on a
drive local to the Server install, especially since you are trying joins.
whether or not the Repository is on a different drive from the SDF files may or
may not make a difference as at some point the data may be cached by Windows,
but if you have more than 4GB of data then that won't be the case. Separating a
Data drive from the Repository would be a good idea.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>To be honest I suspect if you
were to upload your SDF data to SQL Server and create a view in SQL Server you
would see much better performance and more consistent results than by using
joins.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>What is the largest number of
records involved in the joins and are they 1-1 or 1-many relationships?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Dave<o:p></o:p></span></p>
<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>Devadoss,
Bala (US)<br>
<b>Sent:</b> Thursday, August 26, 2010 4:40 PM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> [mapguide-users] RE: Mapguide 2.2 Performance issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Hi Dave,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Sorry for being vague in the
first place. I am still a rookie to the Mapguide Open Source world.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Please find the response below
for your questions. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>What configuration are you using? .NET, APACHE etc..<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:black'>We are using .NET with IIS7 on Windows 2008 Server 64 bit<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'> </span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>Are you using Basic or Flexible Web Layouts? What kind of
data/providers are you using?</span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:black'>We are using Basic Layout embedded in an aspx page. We are
using DWF and SDF files for the graphics with many of the SDF joined via the
ODBC provider for dynamic access to tables in the database as the database is
updated regularly. There is 1 SDF layer, 4 DWF layers, 13 themed SDF/ODBC
joined layers, and 8 labeled SDF/ODBC point layers. The map xml is
generated dynamically based on a user picked value from an aspx page.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>Are you using raster imagery and if so what format?<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:black'>No raster<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'> </span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>Yes the 64 connection limit has been removed, but other
components including the Berkeley database and physical disk I/O for example
will limit the number of concurrent connections?<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:black'>We have followed the criteria for optimized settings based on the
webconfig/serverconfig document that Trevor published.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'> </span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>What is your hardware? How many CPUs/cores? Is everything
running on the same box?<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:black'>Two Virtual machines load balanced using F5 Load Balancer running
MG and the .net code. Both machines have </span><span lang=EN-CA
style='font-size:12.0pt;color:black'>Intel Xeon CPU 2.6ghz 2 processor</span><span
style='font-size:12.0pt;color:black'> with 4 GB of RAM. SQL Server 2008
runs on a separate machine and currently the SDF files are stored on a separate
machine although this was done recently to try and reduce disk IO on the
server.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'> </span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>What are your users doing at the time things lock up?<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:black'>We start at the initial screen and pick a value to load the
map. Two or perhaps three may get the map loaded, all others will sit and
wait until the server ultimately fails.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><b><span style='font-size:12.0pt;
color:#00B050'><o:p> </o:p></span></b></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>Hope this will give you some information on what we did.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>I appreciate your help on this.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>Thanks,<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.15in'><span style='font-size:12.0pt;
color:#1F497D'>Bala <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<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>Dave Wilson<br>
<b>Sent:</b> Wednesday, August 25, 2010 4:09 PM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> [mapguide-users] RE: Mapguide 2.2 Performance issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>You will need to provide a lot
more detail than "it doesn't work" to get a useful response :)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>What configuration are you
using? .NET, APACHE etc..<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Are you using Basic or Flexible
Web Layouts? What kind of data/providers are you using?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Are you using raster imagery and
if so what format?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Yes the 64 connection limit has
been removed, but other components including the Berkeley database and physical
disk I/O for example will limit the number of concurrent connections?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>What is your hardware? How many
CPUs/cores? Is everything running on the same box?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>What are your users doing at the
time things lock up?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Regards,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Dave<o:p></o:p></span></p>
<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>Devadoss,
Bala (US)<br>
<b>Sent:</b> Wednesday, August 25, 2010 3:02 PM<br>
<b>To:</b> mapguide-users@lists.osgeo.org<br>
<b>Subject:</b> [mapguide-users] Mapguide 2.2 Performance issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>We just started testing 64 bit MGO 2.2 on windows 2008R2.
When we load tested our site with 10 simultaneous users, the Mapguide service
stops responding and we had to restart the service.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I thought MGO2.2 is fixed to handle around 500 connections
at the same time compared to 64 connections in MGO2.1.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Please throw some ideas for the performance issue.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal>Bala<o:p></o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>
</span><span style='font-size:12.0pt;font-family:"Courier New"'><br>
<br>
This email is for the use of the intended recipient(s) only. If you have
received this email in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use, disclose,
copy or distribute this email without the author's prior permission. We have
taken precautions to minimize the risk of transmitting software viruses, but we
advise you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by software
viruses. The information contained in this communication may be confidential
and may be subject to the attorney-client privilege. If you are the intended
recipient and you do not wish to receive similar electronic messages from us in
the future then please respond to the sender to this effect.</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>
</span><span style='font-size:12.0pt;font-family:"Courier New"'><br>
<br>
This email is for the use of the intended recipient(s) only. If you have
received this email in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use,
disclose, copy or distribute this email without the author's prior permission.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any attachment
to this message. We cannot accept liability for any loss or damage caused by
software viruses. The information contained in this communication may be
confidential and may be subject to the attorney-client privilege. If you are
the intended recipient and you do not wish to receive similar electronic
messages from us in the future then please respond to the sender to this
effect.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
</body>
</html>