[OSM-dev] mysql partitioning

[SteveC]

* @ 30/08/06 03:08:53 PM nick at nickhill.co.uk wrote:
> Hello Andreas
> 
> I agree, in conjunction with changing lat/lon co-ords to integers, the 
> index look-ups based on lat/lon can be improved perhaps by at least an 
> order of magnitude. By partitioning on longitude, I can imagine those 
> indexes automatically being loaded into and out of memory depending on 
> activity - day or night in the area.
> 
> I have held up doing anything on this whilst Steve puts the API on rails.
> 
> Steve- do you think it reasonable to add a superset of the current API 
> to the API 0.4 where the query and return values are integers for lat/lon?

Yes, but in the rails version. I really hate the idea of continually
munging the old code.

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/