[OSM-dev] Too many slow queries in db

Richard Fairhurst richard at systemeD.net
Tue Sep 4 09:17:01 BST 2007


Brett Henderson wrote:

> Can we build a list of possible improvement areas over current
> database?  This would less any alternatives be measured quantitively.
> For example:
> * The current top 10 slow queries.  Assuming an alternative schema still
> follows the nodes, segments, ways model this would let us manually run
> queries against alternative implementations without porting tools.

I anticipate we'll get a measurable speedup once 0.5 goes live.  
Certainly, Potlatch's queries will be greatly improved by no longer  
having to join everything to the segment tables (and some of them can  
be eliminated entirely).

cheers
Richard





More information about the dev mailing list