[OSM-dev] getnodes query optimization

Christopher Schmidt crschmidt at crschmidt.net
Fri Jun 2 15:50:48 BST 2006


On Fri, Jun 02, 2006 at 03:44:49PM +0100, SteveC wrote:
> * @ 02/06/06 03:37:30 PM crschmidt at crschmidt.net wrote:
> hi
> 
> * there are multiple versions of a node in the table
> 
> * you need to get the latest version of the nodes, hence the order by
> 
> * once you have the latest version you need to check they're still in
> the bounding box, hence the sub-select

Okay.

> Why are you looking at that code?

I'm looking at all the code, trying to find places where it can be
improved upon.

-- 
Christopher Schmidt
Web Developer




More information about the dev mailing list