RoundCube MySQL poor perfomance: migrate to PostgreSQL

[rc-user]

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.

[Pantani]

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.

[rc-user]

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)