[OGo-Users] sence of var lib documents

Stegbauer users@opengroupware.org
Sat, 03 Feb 2007 00:23:51 +0100


> Why would it be stored in the database?

to have one place, where everything is stored.
 
>  - Filesystems are faster; usually much much faster.  It is extremely
>    hard to beat a modern filesystem for straight-out performance.
>  - BLOB access methods are the least portable database access methods
>  - BLOBs frequently are the cause of database storage fragmentation,
>    buffer pool exhaustion, and can clog up transaction logs.
>    -- (Trust me,  I'm an Informix Universal Server DBA; BLOBs can sack
>        your performance if not done very thoughtfully.)

ok

> Since all the access to content in OGo is through a logic layer there
> aren't really any penalties to the current method.  Applications use the
> logic layer, or the logic layer via an RPC method, and the information
> comes from the correct place.

if you want more than one ogo application-server (different version, more performance) as you mentoined in an other email to, you have only half of the data.

 
> And IMAP sieve scripts / vacation messages end up in the Cyrus IMAP
> server's black box anyway.

yes, but this is a one-way. so if you connect to the other server (like described above) ogo doesn't know anything about it, and creates a completly new/empty sieve script.

but i think every solution has advantages/disadvantages, so its ok. (maybe locate /var/lib/opengroupware/documents on a nfs-share ;)

greetings
thomas

-- 
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail?ac=OM.GX.GX003K11713T4783a