[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