On Mon, Dec 15, 2008 at 9:57 AM, Mathieu Arnold <[email protected]> wrote: > +--On 15 décembre 2008 09:41:34 +0000 80n <[email protected]> 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 >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
