[Adium-devl] More Logging Decisions

[Jeffrey Melloy]

On Jun 1, 2006, at 3:37 AM, Peter Hosey wrote:

> On Jun 1, 2006, at 00:54:24, David Smith wrote:
>> XML:
>> 	⋮
>> 	cons: apparently rather slower than properly done sqlite, which is
>> claimed to be a major problem for irc/jabber confs
>
> I doubt this. Modern drives are fast; only a very large write (like  
> a million chats all crying out and then being silent) could cause a  
> stall.
>
>> SQLite:
>> 	pros: probably just a matter of revamping Sam's sqlite logger based
>> on Xenon's schema, and setting fullfync to 0, supposedly faster
>> 	cons: no idea if the other clients like it (We could do export/
>> import to xml though, so this may not be a huge issue), not as human
>> readable

Don't underestimate not human readable.  I'd far rather have my logs  
in an XML format than solely SQLLite.  I'll believe the speed  
criticisms when I see it; flipping some magic bit in SQLLite  
shouldn't have that big of an affect.  "As of this writing, only Mac  
OS X support F_FULLFSYNC." is the only information I can find on it.

> Truth.
>
>> Both can handle spotlight, and Colin says he's worked out how to  
>> do phrase searching for sqlite if we use it. … The limitations of  
>> it won't become apparent (if they become apparent) until we have  
>> really solid group chat.
>
> So we can use SQLite in 1.5 for group chat if it turns that that  
> XML logging is too slow.

Cross that bridge when we come to it, and all that.

I would stick with XML for now.  If you really want to keep having  
this discussion, update the SQLLite logger in tandem.

Jeff