[OSM-dev] mysql partitioning

Richard Fairhurst richard at systemeD.net
Wed Aug 30 15:30:05 BST 2006


Nick H wrote:

> However, most of the database time seems to be spent pulling segments
> from the database. For every node in the selected area, an index
> look-up is performed for segments associated with that node. Then for
> segments which have only one node associated with them, the other node
> is downloaded. This is very, very db intensive.

<stuck record>
Removing segments and making ways a list of ordered nodes would also  
reduce the db load here.
</stuck record>

cheers
Richard





More information about the dev mailing list