<html 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="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 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ET link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Hi<br>
<br>
I’ve been using Minnesota Mapserver for a while with a big success.
Though I haven’t understood completely which file formats to read fits
best for Mapserver.<br>
<br>
Biggest mystery is shape file. It should be the fastest file format to read,
but it’s been the slowest in all my tests.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Like one test I made with
Mapinfo TAB, ESRI shape, PostGIS database table and shptree file.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>I had at first one
MapInfo dataset (33 Mb). To get shape file I translated it with MapInfo’s
Universal Translator. From shape file I made qix file with shptree in depth 8
and using shp2pgsql I created database entry file (I also indexed postgis
table)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Then I put together 4
different map files to read these. Test was made with single and concurrent
queries (500 queries for each map file).<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'>The results are as follows:<o:p></o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=400
style='width:300.0pt;margin-left:-1.15pt;border-collapse:collapse'>
<tr height=17 style='height:12.75pt'>
<td width=121 nowrap height=17 valign=bottom style='width:90.75pt;border:
solid windowtext 1.0pt;padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>File Type<o:p></o:p></span></font></p>
</td>
<td width=107 nowrap height=17 valign=bottom style='width:80.25pt;border:
solid windowtext 1.0pt;border-left:none;padding:0cm 3.5pt 0cm 3.5pt;
height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Time per request<o:p></o:p></span></font></p>
</td>
<td width=172 nowrap height=17 valign=bottom style='width:129.0pt;border:
solid windowtext 1.0pt;border-left:none;padding:0cm 3.5pt 0cm 3.5pt;
height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Time per concurrent request<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=121 nowrap height=17 valign=bottom style='width:90.75pt;border:
solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;
height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>TAB<o:p></o:p></span></font></p>
</td>
<td width=107 nowrap height=17 valign=bottom style='width:80.25pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="77.522999999999996">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>78<o:p></o:p></span></font></p>
</td>
<td width=172 nowrap height=17 valign=bottom style='width:129.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="30.199000000000002">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>30<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=121 nowrap height=17 valign=bottom style='width:90.75pt;border:
solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;
height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>SHP<o:p></o:p></span></font></p>
</td>
<td width=107 nowrap height=17 valign=bottom style='width:80.25pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="835.346">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>835<o:p></o:p></span></font></p>
</td>
<td width=172 nowrap height=17 valign=bottom style='width:129.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="579.17399999999998">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>579<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=121 nowrap height=17 valign=bottom style='width:90.75pt;border:
solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;
height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>SHP with qix<o:p></o:p></span></font></p>
</td>
<td width=107 nowrap height=17 valign=bottom style='width:80.25pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="822.40300000000002">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>822<o:p></o:p></span></font></p>
</td>
<td width=172 nowrap height=17 valign=bottom style='width:129.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="579.72799999999995">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>580<o:p></o:p></span></font></p>
</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td width=121 nowrap height=17 valign=bottom style='width:90.75pt;border:
solid windowtext 1.0pt;border-top:none;padding:0cm 3.5pt 0cm 3.5pt;
height:12.75pt'>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>PostGIS<o:p></o:p></span></font></p>
</td>
<td width=107 nowrap height=17 valign=bottom style='width:80.25pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="68.77">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>69<o:p></o:p></span></font></p>
</td>
<td width=172 nowrap height=17 valign=bottom style='width:129.0pt;border-top:
none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
padding:0cm 3.5pt 0cm 3.5pt;height:12.75pt' x:num="18.766999999999999">
<p class=MsoNormal align=right style='text-align:right'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>19<o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>* Times are in
milliseconds<br>
<br>
Why is shape so slow?!? I appreciate any help to find answer to this question. <br>
<br>
Sincerely,<br>
Erki Saluveer<o:p></o:p></span></font></p>
</div>
</body>
</html>