Gerald, > I play with the idea to use amavisd-new, sqlite and MailZu on > very small servers with only a few users. I think that it should > be possible for amavisd-new to use sqlite for writing if I > limit the concurrent processes to 1. To get some mails a little > bit later I can tolerate. Mysql or postgres are too heavy for > this task.
I think it should work just fine if the concurrency is kept low on the average. I did test amavisd-new with SQLite, it does work fine, but for our needs the write conflicts on transactions were too frequent to be acceptable as a log/reporting database. On the other hand, SQLite is perfect for read-only access such as SQL lookups. So if one needs the flexibility of SQL lookups (no need to reload amavisd on changes) and wants to avoid the complexity of full client/server SQL, a database all-in-one-file is a perfect solution, fast too. Mark ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
