[OSM-dev] Osmarender not always showing latest data
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...
More information about the dev