https://sourceforge.net/apps/phpbb/travelingsales/viewtopic.php?f=4&t=93
Does anyone have experience with Mysql and 2d-range-queries? I am looking for the optimal way of: a) selecting all nodes in a given bounding-box and b) selecting all ways intersecting a given bounding-box. I am not bound to any existing schema. What works best? * index on "lat" and index on "lon" * throwing the first normal form out the window and having a geometry-POINT plus the coordinates in a node -table * using an interleaved "tilenumber" -column * ... Marcus _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
