amillb / pgMapMatch

map-matching of GPS traces
MIT License
77 stars 20 forks source link

Restrict pgrouting query to bounding box #1

Closed amillb closed 6 years ago

amillb commented 7 years ago

This should improve the performance of 'updateCostMatrix()` and deal with memory issues.

See http://docs.pgrouting.org/latest/en/pgRouting-concepts.html#performance

amillb commented 6 years ago

Let's not do this, because that will slow down queries given the need to select a subset of the streets table each time.

Rather, raise a warning for large streets tables and suggest that the user use a subset of streets.