[OGo-Developer] Re: additional field for synchronizatin

Helge Hess developer@opengroupware.org
Fri, 24 Aug 2007 23:51:12 +0200


On 24.08.2007, at 21:55, Wolfgang Sourdeau wrote:
> The chances that 2 users modify the same event (for exmaple, one  
> change the start hour and the other deletes it) are really close to  
> 0.0000001%.

The question is not how often a conflict happens per day or sync but  
per 5-years and not for 2 users but for 1000+ users (in the SOGo case  
many more) which synchronize their 1000+ events when they arrive in  
the office at 8:30.

Now if you are happy you might never encounter a conflict, but keep  
in mind that PostgreSQL can easily perform 10.000 updates per second  
on modern hardware so one second of granularity *is* quite broad.  
Then consider that concurrent changes to a shared item are much more  
likely than changes to some private, old or new item.

This keeps me concerned (but not overly, especially if the users are  
told about the potential issue). And its really only an issue for  
large deployments.

> So I would not worry about that at all.

As mentioned before I think its OK no to worry about it now. But  
maybe doing it transactionally safe isn't that much harder either?
If its too hard to bother, it fine for me.

Summary: I'm not exactly pleased about an implementation which relies  
on timestamps instead of exact states. But I'm even less pleased  
about not having an implementation at all :-)

So, no need to argue any further. I'm fine if you contribute an  
implementation doing it the way you outlined!

Thanks,
   Helge