Author Topic: RoundCube MySQL poor perfomance: migrate to PostgreSQL  (Read 5233 times)

Offline rc-user

  • Newbie
  • *
  • Posts: 4
RoundCube MySQL poor perfomance: migrate to PostgreSQL
« 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.
« Last Edit: February 08, 2012, 04:44:22 PM by rc-user »

Offline Pantani

  • Jr. Member
  • **
  • Posts: 18
RoundCube MySQL poor perfomance: migrate to PostgreSQL
« Reply #1 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.

Offline rc-user

  • Newbie
  • *
  • Posts: 4
RoundCube MySQL poor perfomance: migrate to PostgreSQL
« Reply #2 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)