[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