<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Any,<br>
      <br>
       Back in late 2009 (search the email list in Dec 2009 and Mar
      2010) there was an effort to implement RFC 52: One-pass query
      processing (<a class="moz-txt-link-freetext" href="http://mapserver.org/development/rfc/ms-rfc-52.html">http://mapserver.org/development/rfc/ms-rfc-52.html</a>),
      but I'm not sure if it was implemented. (Status=draft?).  <br>
      <br>
        Dunno if it relates to your problem...<br>
      <pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
      On 4/10/2013 2:23 PM, deuce2367 wrote:<br>
    </div>
    <blockquote
cite="mid:CAEgGcFYAvF_GEbNtFhx_+BAh814=fKe8pJ2voaPswHg1AgBndw@mail.gmail.com"
      type="cite">
      <div dir="ltr">Steve,
        <div><br>
        </div>
        <div style="">That's a good suggestion.  I'm running a very
          simple test where I use shp2img with a straightforward map
          file but if I used ogr2ogr that would take Mapserver out of
          the equation altogether.  I'll try and set up such a test and
          see what happens.</div>
        <div style=""><br>
        </div>
        <div style="">Cheers,</div>
        <div style=""><br>
        </div>
        <div style="">-Andy</div>
      </div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">On Wed, Apr 10, 2013 at 2:06 PM, Lime,
          Steve D (MNIT) [via OSGeo.org] <span dir="ltr"><<a
              moz-do-not-send="true"
              href="/user/SendEmail.jtp?type=node&node=5045913&i=0"
              target="_top" rel="nofollow" link="external">[hidden
              email]</a>></span> wrote:<br>
          <blockquote style="border-left:2px solid #CCCCCC;padding:0
            1em" class="gmail_quote">
            <div class="im"> Is there a way to test your theory
              independent of MapServer using OGR only? I don't know the
              MapServer OGR driver well but I can't imagine this is
              normal.
              <br>
              <br>
              Steve
              <br>
              <br>
              -----Original Message-----
              <br>
            </div>
            <div class="im">From: <a moz-do-not-send="true"
                href="http://user/SendEmail.jtp?type=node&node=5045879&i=0"
                rel="nofollow" link="external" target="_blank">[hidden
                email]</a> [mailto:<a moz-do-not-send="true"
                href="http://user/SendEmail.jtp?type=node&node=5045879&i=1"
                rel="nofollow" link="external" target="_blank">[hidden
                email]</a>] On Behalf Of deuce2367
              <br>
              Sent: Tuesday, April 09, 2013 9:20 AM
              <br>
            </div>
            <div class="im">To: <a moz-do-not-send="true"
                href="http://user/SendEmail.jtp?type=node&node=5045879&i=2"
                rel="nofollow" link="external" target="_blank">[hidden
                email]</a>
              <br>
              Subject: [mapserver-dev] OGR/MySQL Layer executes SQL
              query twice
              <br>
              <br>
              I'm using Mapserver 6.0.2 and GDAL 1.7.2 and have created
              a mapfile with an OGR/MySQL layer.  The SQL query that
              retrieves the spatial data is fairly slow, takes about
              8-10 seconds.  I've noticed that whenever I render the
              layer (via the mapserv binary or via the shp2img utility)
              that the query executes two times.  I thought this was
              maybe some sort of introspection/reflection issue where
              perhaps OGR is trying to characterize the data somehow so
              I made sure to create and populate the geometry_columns
              table but that doesn't seem to help, it's still running
              the SQL query twice. <br>
              Incidentally it's also performing 2 describes and 2
              'select from geometry_columns...' as well.
              <br>
              <br>
              Is this normal and expected? <br>
              <br>
              I apologize if this is a repeat, I didn't find any
              references to this observation in my searches.  Appreciate
              any help,
              <br>
              <br>
              -Andy Smith
              <br>
              <br>
              <br>
              <br>
              <br>
              --
              <br>
              View this message in context: <a moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536.html"
                rel="nofollow" link="external" target="_blank">http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536.html</a><br>
              Sent from the Mapserver - Dev mailing list archive at
              Nabble.com.
              <br>
              _______________________________________________
              <br>
              mapserver-dev mailing list
              <br>
            </div>
            <a moz-do-not-send="true"
              href="http://user/SendEmail.jtp?type=node&node=5045879&i=3"
              rel="nofollow" link="external" target="_blank">[hidden
              email]</a>
            <br>
            <a moz-do-not-send="true"
              href="http://lists.osgeo.org/mailman/listinfo/mapserver-dev"
              rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-dev</a><br>
            <br>
            <br>
            _______________________________________________
            <br>
            mapserver-dev mailing list
            <br>
            <a moz-do-not-send="true"
              href="http://user/SendEmail.jtp?type=node&node=5045879&i=4"
              rel="nofollow" link="external" target="_blank">[hidden
              email]</a>
            <br>
            <a moz-do-not-send="true"
              href="http://lists.osgeo.org/mailman/listinfo/mapserver-dev"
              rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-dev</a><br>
            <br>
            <br>
            <hr size="1" color="#cccccc" noshade="noshade">
            <div style="color:#444;font:12px
              tahoma,geneva,helvetica,arial,sans-serif">
              <div style="font-weight:bold">If you reply to this email,
                your message will be added to the discussion below:</div>
              <a moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536p5045879.html"
                target="_blank" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536p5045879.html</a>
            </div>
            <div style="color:#666;font:11px
tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
              To unsubscribe from OGR/MySQL Layer executes SQL query
              twice, <a moz-do-not-send="true" href="" target="_blank"
                rel="nofollow" link="external">click here</a>.<br>
              <a moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml"
                rel="nofollow" style="font:9px serif" target="_blank"
                link="external">NAML</a> </div>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <hr width="300" align="left">
      View this message in context: <a moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/OGR-MySQL-Layer-executes-SQL-query-twice-tp5045536p5045913.html">Re:
        OGR/MySQL Layer executes SQL query twice</a><br>
      Sent from the <a moz-do-not-send="true"
        href="http://osgeo-org.1560.x6.nabble.com/Mapserver-Dev-f4252683.html">Mapserver
        - Dev mailing list archive</a> at Nabble.com.<br>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
mapserver-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-dev@lists.osgeo.org">mapserver-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-dev">http://lists.osgeo.org/mailman/listinfo/mapserver-dev</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>