web stats
Mirth Connect Message Store Performance - Postgres vs. MySQL - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2016, 02:13 PM
justinsk justinsk is offline
What's HL7?
 
Join Date: Feb 2010
Location: Los Angeles
Posts: 5
justinsk is on a distinguished road
Question Mirth Connect Message Store Performance - Postgres vs. MySQL

We've done some testing with Mirth using Postgres and MySQL as the message store and have found performance to be surprisingly different.

Our tests were on AWS hosted RDS, on equal resources. Most of the settings were default. Using official Oracle JRE for Mirth, also on AWS.

With the identical channel, we are getting about 22 messages / second on MySQL and 58 on Postgres.

In reading the docs and forums, it seems Postgres is the recommended version and fan favorite. The questions we have to the community are:
  • Are there any special settings for MySQL that others have figured out?
  • Has anybody else seen the same performance difference and is Postgres really the way to go?

Appreciate the insight,

Justin
Reply With Quote
Reply

Tags
mysql, performance, postgres, slow

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 09:50 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation