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

SteveC steve at asklater.com
Wed May 16 13:20:13 BST 2007


On 16 May 2007, at 09:48, Richard Fairhurst wrote:

> 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'.

because then what's the difference between deleted and none returned?

/api/0.4/segment/42 needs to tell you 410 GONE or 404 NOT FOUND somehow.

>
> 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/






More information about the dev mailing list