Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: rc-user on February 08, 2012, 04:43:29 PM

Title: RoundCube MySQL poor perfomance: migrate to PostgreSQL
Post by: rc-user on February 08, 2012, 04:43:29 PM

RoundCube perfomance very poor when using MySQL with above 1000 contacts stored in database (see http://www.roundcubeforum.net/3-news-announcements/12-general-discussion/9396-roundcube-perfomance-bug-contacts-above-1000-mysql.html). How to migrate existing database (users, contacts, etc) from MySQL to PostgreSQL ? Any working examples, scripts will be very appreciated.

Title: RoundCube MySQL poor perfomance: migrate to PostgreSQL
Post by: Pantani on February 09, 2012, 04:50:49 AM

It must be simple when you have a normal schema from RC distribution in your mysql. I think these steps must do the job:
1) create postgresql according to the RC distro schema
2) export mysql data to INSERT commands
3) import INSERTs into pgsql. If it failes, repair the inserts, but I think this generally should work.

Title: RoundCube MySQL poor perfomance: migrate to PostgreSQL
Post by: rc-user on February 11, 2012, 07:46:15 AM

Thanks for advice, it helped. Unfortunatly moving to PostgreSQL don't fixed low perfomance. I had opened new bug in bugtracker about it - #1488345 (RoundCube perfomance bug with contacts above 1000 in MySQL) (http://trac.roundcube.net/ticket/1488345)