Upcoming release notes
With the upcoming release 0.1.4 of conjoon you’ll be able to manage attachments for your Emails. While functionality has been quickly implemented (the GUI has been updated with a number of nifty features), we decided to add full support for storing LOBs in the server’s filesystem.
There are a number of reasons why one would rather not store LOBs into the database – mainly performance wise.
conjoon 0.1.4 will introduce a few new configuration options regarding LOB storage – which can be even changed during runtime. The backend will still maintain relations between the filesystem and the database to keep data integrity – while providing a performance boost and simultaneously reduce space needed by the database to store files, attachments and raw email sources.
So what does this mean for you? First off, the install wizard will be updated to guide you through the needed steps for setting up file system LOB storage. No data has to be migrated, even if you decide to use filesystem LOB storage (resources for LOBs will be determined during runtime). All you have to do is to take proper care of the file permissions to prevent security issues. However, we give advices during setup where necessary – in the end you’re still able to configure your installation to store LOBs in the db.
See http://www.siteartwork.de/2010/06/01/conjoon-dev-notes/ for a related article that describes our new feature more detailed.