<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 style="MARGIN: 4px 4px 1px">
<DIV>Sounds like quite an impediment. Any idea when v6.0 is likely to be released?</DIV>
<DIV> </DIV>
<DIV>Robert<BR><BR>>>> Frank Warmerdam <warmerdam@pobox.com> 1/04/2009 2:07 p.m. >>><BR>joncoign wrote:<BR>> I have a WFS layer that is querying the database via an OGR ODBC connection<BR>> once per point included in the result set plus one additional query. I was<BR>> under the impression that this should only execute once. Am I<BR>> misunderstanding or do I have something misconfigured? Map file and SQL<BR>> Profiler output below.<BR><BR>Jon,<BR><BR>Your profiling is correct. The MapServer query mechanism as it exists in<BR>5.4 (and since the beginning of time) results in many small queries against<BR>OGR, and other database backends. It is for exactly this reason that Steve<BR>is re-engineering the query mechanism for 6.0 to do "single pass query".<BR><BR>The situation should improve substantially in 6.0.<BR><BR>I would note this problem with many small queries applies only to the<BR>query mechanism, not map drawing which just does one query per layer draw.<BR><BR>Best regards,<BR>-- <BR>---------------------------------------+--------------------------------------<BR>I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>light and sound - activate the windows | <A href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A><BR>and watch the world go round - Rush | Geospatial Programmer for Rent<BR><BR>_______________________________________________<BR>mapserver-users mailing list<BR>mapserver-users@lists.osgeo.org<BR><A href="http://lists.osgeo.org/mailman/listinfo/mapserver">http://lists.osgeo.org/mailman/listinfo/mapserver</A>-users<BR><BR></DIV><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>