<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.5726" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Microsoft Sans Serif">
<DIV>I added the OracleSpatial patch to track as #2933.</DIV>
<DIV> </DIV>
<DIV>On our 220k point address database the query time went from 6 minutes down to 32 seconds and produced about 360K of GML.</DIV>
<DIV><BR>>>> On 3/10/2009 at 10:33 AM, Paul Ramsey <pramsey@opengeo.org> wrote:<BR></DIV>
<DIV style="PADDING-LEFT: 7px; MARGIN: 0px 0px 0px 15px; BORDER-LEFT: #050505 1px solid; BACKGROUND-COLOR: #f3f3f3">I have updated the PostGIS driver in the sandbox to use the new logic.<BR>My timing on outputting 5Mb of GML via WFS query has gone from 12s to<BR>0.5s, a 24x improvement.<BR><BR>Great work Steve!<BR><BR>P.<BR>_______________________________________________<BR>mapserver-dev mailing list<BR>mapserver-dev@lists.osgeo.org<BR><A href="http://lists.osgeo.org/mailman/listinfo/mapserver">http://lists.osgeo.org/mailman/listinfo/mapserver</A>-dev<BR></DIV></BODY></HTML>