<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>File Format Performance</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Hi All,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">I know this will be a bit of an open question, but I am looking for a general answer.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Currently I use ESRI Shape files with my MapServer implem</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">entation</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans"> (and this performs OK)</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">, but I am building a new server and I have installed PostgreSQL on this new server.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">So what I want to know is:</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">1. Are ESRI Shape files the best file format for MapServer?</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">2. Will</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Lucida Sans">storing all my data in PostgreSQL be faster (at rendering with php_mapscript) than ESRI Shape files</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">3. Is there another options that is better (faster) than PostgreSQL or Shape files (</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">e.g.</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"> <FONT SIZE=2 FACE="Lucida Sans">another file format)?</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Cheers Ian</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">______________________<BR>
</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Ian Tidy</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><BR>
</SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">GIS Analyst / Developer</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><BR>
</SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Works Asset Department<BR>
Napier City Council<BR>
Hastings St, Private Bag 6010, Napier, New Zealand<BR>
</FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"></SPAN></B><B><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Phone +64-6-835-7579 Ext. 8115</FONT></SPAN></B><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><BR>
</SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Skype</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans"> ian.tidy.ncc<BR>
</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans">Fax</FONT></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans"> +64-6-8</FONT><FONT SIZE=2 FACE="Lucida Sans">34-4195<BR>
</FONT></SPAN><SPAN LANG="en-nz"></SPAN><A HREF="mailto:iant@napier.govt.nz"><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><U></U></SPAN><U><SPAN LANG="en-nz"></SPAN></U><U><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Lucida Sans">mailto:iant@napier.govt.nz</FONT></SPAN></U><SPAN LANG="en-nz"></SPAN></A><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><BR>
</SPAN><SPAN LANG="en-nz"></SPAN><A HREF="http://www.napier.govt.nz"><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><U></U></SPAN><U><SPAN LANG="en-nz"></SPAN></U><U><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Lucida Sans">http://www.napier.govt.nz</FONT></SPAN></U><SPAN LANG="en-nz"></SPAN></A><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans"> |</FONT></SPAN><SPAN LANG="en-nz"> </SPAN><A HREF="http://maps.napier.govt.nz"><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><U></U></SPAN><U><SPAN LANG="en-nz"></SPAN></U><U><SPAN LANG="en-nz"><FONT COLOR="#0000FF" SIZE=2 FACE="Lucida Sans">http://maps.napier.govt.nz</FONT></SPAN></U><SPAN LANG="en-nz"></SPAN></A><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Lucida Sans"></FONT></SPAN><SPAN LANG="en-nz"><B></B></SPAN><SPAN LANG="en-nz"><B></B></SPAN><B><SPAN LANG="en-nz"> </SPAN></B></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN><SPAN LANG="en-nz"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-nz"></SPAN></P>
<HR>
This e-mail message has been scanned for Viruses and Content and cleared by
<FONT color=#400080><STRONG>MailMarshal </STRONG></FONT>
<HR>
<FONT
size=1>######################################################################<BR>Attention:
<BR>This e-mail message and accompanying data may contain information that<BR>is
confidential and subject to legal privilege. Any information<BR>provided is
given in good faith. However unless specifically stated to<BR>the contrary,
Napier City Council accepts no liability for the<BR>content of this e-mail or
for the consequences of any action taken on<BR>the basis of the information
provided, unless that information is<BR>subsequently confirmed in writing. If
you are not the intended recipient,<BR>you are notified that any use,
dissemination, distribution or copying<BR>of this message or data is prohibited.
If you received this e-mail<BR>message in error, please notify us immediately
and erase all copies<BR>of this message and attachments. Thank you.
</FONT>
</BODY>
</HTML>