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

Richard Fairhurst richard at systemeD.net
Wed May 16 09:48:59 BST 2007


SteveC wrote:

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

Yeah, I know _that_ ;).

I'm just not sure why we keep deleted segments in the  
'current_segments' table anyway. Strikes me that they don't have any  
use outside the history table, i.e. 'segments'.

cheers
Richard





More information about the dev mailing list