<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    bbox queries using the built in spatial indexing presumably? OSM has
    it's own magical bitmask for that, that may also be as fast in
    mongo, who knows.<br>
    <br>
    On 4/11/2011 5:58 PM, Ian Dees wrote:
    <blockquote
      cite="mid:BANLkTikfgCPQNJkgNAwCcqu-1_-Z+KDg6Q@mail.gmail.com"
      type="cite">
      <div class="gmail_quote">On Mon, Apr 11, 2011 at 6:36 PM, Sergey
        Galuzo <span dir="ltr"><<a moz-do-not-send="true"
            href="mailto:sergal@microsoft.com">sergal@microsoft.com</a>></span>
        wrote:<br>
        <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
          0.8ex; border-left: 1px solid rgb(204, 204, 204);
          padding-left: 1ex;">
          <div link="blue" vlink="purple" lang="EN-US">
            <div>
              <p class="MsoNormal"><span>Hi,</span></p>
              <p class="MsoNormal"><span> </span></p>
              <p class="MsoNormal"><span>I am working on evaluation of
                  MongoDB for several storage solutions at hand. Some of
                  them resemble current OSM editing database. I have
                  heard that OSM dev is/was evaluating MongoDB also. I
                  was wondering whether it possible to share the
                  findings?</span></p>
              <p class="MsoNormal"><span> </span></p>
            </div>
          </div>
        </blockquote>
        <div><br>
        </div>
        <div>In my experimentation with MongoDB (seen here: <a
            moz-do-not-send="true"
            href="https://github.com/iandees/mongosm/">https://github.com/iandees/mongosm/</a>)
          I found it to be very slow. Inserts were speedy, but
          bounding-box queries took a long time.</div>
        <div><br>
        </div>
        <div>The most recent dev version of MongoDB includes
          "multi-location documents" support:</div>
        <div>
          <meta http-equiv="content-type" content="text/html;
            charset=ISO-8859-1">
          <a moz-do-not-send="true"
href="http://www.mongodb.org/display/DOCS/Geospatial+Indexing#GeospatialIndexing-MultilocationDocuments">http://www.mongodb.org/display/DOCS/Geospatial+Indexing#GeospatialIndexing-MultilocationDocuments</a></div>
        <div><br>
        </div>
        <div>This would allow a single way document to be indexed at
          multiple locations and vastly speed up the map query.</div>
        <meta http-equiv="content-type" content="text/html;
          charset=ISO-8859-1">
      </div>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/listinfo/dev">http://lists.openstreetmap.org/listinfo/dev</a>
</pre>
    </blockquote>
  </body>
</html>