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

[SteveC]

On 15 May 2007, at 17:44, Richard Fairhurst wrote:
> 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.)

select * from current_segments where id = 42;


visible:

1 = there
0 = deleted
none returned = not created yet


>
> cheers
> Richard
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>

have fun,

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