<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY>
<DIV>Hi Sam</DIV>
<DIV> </DIV>
<DIV>I would try turning the Coastline layer into a Shapefile and serving it from the Mapserver machine in a local directory. Postgis is probably overkill given the layer is probably static (unlikely to need changing).</DIV>
<DIV> </DIV>
<DIV>regards,</DIV>
<DIV> </DIV>
<DIV>Robert<BR><BR>>>> Sam Ingarfield <sjfingarfield@gmail.com> 7/05/2009 2:27 a.m. >>><BR>Hi;<BR><BR>I've just been through a bit of an optimisation process on my server and was wondering whether the speeds that I am obtaining are somewhat inline with what could be expected with the hardware/datasets that are in use.<BR><BR>Firstly: Hardware.<BR>2.2Ghz Xeon (Single Core, but with hyperthreading. not that hyperthreading helps much.)<BR>1.2Gb Memory coupled with over 2Gb of swap (was filling up memory and original swap realllly fast so swap was expanded)<BR>Data being served off an array of three ultra320 15k scsi drives in a raid-5 config.<BR><BR>Software.<BR>OS: Debian<BR>Mapserver: Nighly build as of 6/5/09, in fastcgi mode<BR>Data source: Postgis database<BR><BR>Data:<BR>Coastline Layer (9 Polygons with a stupid number of vertices, this is a known slow point due to toast table problems. or at least we think it is)<BR>Islands Layer (~9000 polygons, only ~4mb)<BR>Internal Waterbodies layer (~11000 polygons, plus ~1.2m lines, 800mb all up)<BR><BR>Performance:<BR>On a moderate zoom level, about 2s per 256x256 tile.<BR>On more zoomed out levels, process times out before completing. and yes, some generalisation needs to take place at further out zoomage but thats not sorted yet.<BR>If i drop the coastline layer out (the toast problem one), speed ups to like 80-100ms/tile<BR><BR><BR>So, watchathink?<BR><BR><BR><BR></DIV><FONT style="BACKGROUND-COLOR: #ffffff">
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">Click <A href="https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==">here</A> to report this email as spam.</FONT></P></FONT><br><br><table bgcolor=white style="color:black"><tr><td><br>------------------------------------------------------------------<br>
The contents of this email are confidential to AsureQuality. If you have received this communication in error please notify the sender immediately and delete the message and any attachments. The opinions expressed in this email are not necessarily those of AsureQuality. This message has been scanned for known viruses before delivery. AsureQuality supports the Unsolicited Electronic Messages Act 2007. If you do not wish to receive similar communications in future, please notify the sender of this message.<br>
------------------------------------------------------------------</td></tr></table><br><br>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been scanned for malware by SurfControl plc. </FONT><A href="http://www.surfcontrol.com/"><FONT style="BACKGROUND-COLOR: #ffffff" color=#000000>www.surfcontrol.com</FONT></A></P>
</body></HTML>