[OSM-dev] rails schema + mysql on dev v slow
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;
>> 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.
> dev mailing list
> dev at openstreetmap.org
SteveC | steve at asklater.com | http://www.asklater.com/steve/
More information about the dev