Jerry jerry@seibercom.net wrote:
On Mon, 21 May 2012 06:14:10 -0400 Charles Marcus articulated:
On 2012-05-20 1:48 PM, Luuk@dovecot dovecot@vosslamber.nl wrote:
SQlite is only 61Kb, no config is needed
If you start using MySQL, and the MySQL-database is changed because of some upgrades to the system that currenly uses it, it might have an impact on your mail-system....
For that 2 cents, i would install SQlite!
Out of curiousity...
How is the performance of SQLite? I'm assuming it is only recommended for servers that are not under heavy load...
What are the main advantages/disadvantages of using SQLite over MySQL?
I found numerous links for just that sort of information on Google & Bing. These two seem rather informative.
http://stackoverflow.com/questions/2824135/how-fast-is-berkeley-db-sql-compa... http://www.oracle.com/technetwork/database/berkeleydb/learnmore/bdbvssqlite-...
Hmm.
Those documenets only talk about heavy writing to the database which is not involved in the Dovecot scenario discussed here, where the database is used as a data storage for the configuration which is mostly read.
So the question, how fast SQLite is during read operations compared to BDB is still unanswered.
Grüße, Sven.
-- Sigmentation fault. Core dumped.