Converting RoundCube database from MySQL to SQLite question

copernic2006

• February 28, 2017 04:39

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

  • February 28, 2017 14:24

  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

  0
• 

  cPanelMichael

  • February 28, 2017 18:54

  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.

  0

Please sign in to leave a comment.