[OSM-dev] Osmarender not always showing latest data

80n 80n80n at gmail.com
Mon Dec 15 23:43:36 GMT 2008


On Mon, Dec 15, 2008 at 9:57 AM, Mathieu Arnold <mat at mat.cc> wrote:

> +--On 15 décembre 2008 09:41:34 +0000 80n <80n80n at gmail.com> wrote:
> | Are you saying, very simply, a count of all the tags for nodes, ways and
> | relations for any given timestamp?
> |
> | For example:
> | 2008-12-15 08:04 = 898266982
> | 2008-12-15 08:05 = 898278312
> | 2008-12:15 08:06 = 898279938
> | etc
> |
> | I was thinking of something with a little bit more granularity, such as
> | the sum of the seconds component of each time stamp.  This would also, I
> | think, be quicker to recalculate if needed.
> |
> | If the checksum was stored in a table for every minute diff update then,
> | if something goes wrong, it would be easy to see when it went wrong, and
> | make it easier to correct by re-running diffs from that moment.
>
> I don't know how much time it would take on other ROMA to select count(*)
> from nodes, but on mine, it's more than a few minutes, so, it could not be
> done every minute :-)
>

Well the obvious way to do it is to maintain a count of insertions, updates
and deletions.  Scanning the whole table every time would be silly.



>
> It could be done every hour or so though.
>
> --
> Mathieu Arnold
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20081215/b4e8e2f2/attachment.html>


More information about the dev mailing list