[OSM-dev] Database Schema (was Re: [OSM-talk] Oh dear - planet has duplicate id's)

[SteveC]

On 23 Jun 2007, at 15:18, Tom Hughes wrote:

> In message <DFE77279-4DDA-45E2-8146-466A0E6F32EF at asklater.com>
>           SteveC <steve at asklater.com> wrote:
>
>> On 23 Jun 2007, at 12:02, Tom Hughes wrote:
>>
>>>   gpx_files
>>>
>>>     - What is the visible field for here? There are a few records
>>>       with it set to zero but the code ignores it - if it isn't
>>>       used then let's remove it.
>>
>> isnt that whats used to delete them?
>
> Sort of - the current site doesn't support deletion of course because
> it needs reimplementing.
>
> I've just looked at the old site and it seems that when you asked to
> delete a trace visible was set to false and then the GPX daemon would
> delete the record properly in the background.
>
> So presumably the 86 files currently in the DB with visible=0 should
> really be deleted... Quite why the GPX daemon didn't do it I don't  
> know.
>
> Going forward I don't really see why deletes need to be done in the
> background (it isn't a slow task like the import) so there doesn't
> seem to be any reason to keep the field.

No - it was really slow deleting traces and it locked the table. Esp.  
when petter was uploading 70 million point gpx files.

have fun,

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070623/8f29f140/attachment.html>