[OSM-dev] rails schema + mysql on dev v slow

Richard Fairhurst richard at systemeD.net
Tue May 15 17:44:10 BST 2007


Dan Moore wrote:

> the rails db/schema.rb creates 'current_nodes_id_idx' on   
> 'current_nodes' which seems to duplicate the primary key id index   
> created by default.  should this be removed?

As a point of comparison, current_segments has a compound index on id  
and visible.

(What do we gain from having nodes/segments/ways with visible=0 in the  
current_ tables anyway? Genuine question.)

cheers
Richard





More information about the dev mailing list