Converting RoundCube database from MySQL to SQLite question

[copernic2006]

Hello,
Can you please tell me the benefits of converting the RoundCube database from Mysql to Sqlite?
Does this conversion bring a benefit to the loadserver?. My stats shows me hugely Imap and webmail session which tends to increase the server load.

 

[mtindor]

For one, the single Roundcube DB (that holds all data for all domains) is replaced with individual SQLite DBs per email account. So [in my mind] the important thing to take away from this is that a single DB corruption will not lead to widspread issues for all email users since each user will now have their own DB.

I don't know whether you can expect any decreased server load. Even if all of your accounts were IMAP, I would doubt that access to the single Roundcube MySQL DB would be causing an increased load.

Mike

 

[cPanelMichael]

Hello,

It's difficult to know for sure if converting to SQLite will offer a performance increase on your system, however there are additional benefits to using SQLite, as documented at:

How to Convert Roundcube to SQLite - cPanel Knowledge Base - cPanel Documentation

Thank you.