Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Message per second count for Mirth DB

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Message per second count for Mirth DB

    I would like to get an idea of how fast Mirth is processing records on our server. It seems Mirth is running alot slower then I expected. I have a main channel that feeds 5 sub channels. The main channel doesn't wait for a response on any of the sub channels. I do store messages in the DB, which I know will drop the throughput.

    Is there a query that can be run against the Mirth DB to get the messages per ______?

    I am using SQL 2k5 for the Mirth database.
    Reid Hospital and Healthcare

  • #2
    Re:Message per second count for Mirth DB

    You could do a filter on the message browser for a 1 minute time period and divide the number of messages returned by 60. My experience with SQL Server and MySQL as the backends for Mirth has been very bad. Both performed very slowly, especially under high volume. I'd look into getting an appliance from WebReach where you get a tuned PostgreSQL database.
    Brendan Haverlock | Mirth Software Engineer | Mirth Corporation

    Comment


    • #3
      Re:Message per second count for Mirth DB

      Wow!! Switching to a PostgreSQL DB is like a night and day difference.

      Is there a particular reason that there is a monumental difference between DB performance when using them for the Mirth database?
      Reid Hospital and Healthcare

      Comment


      • #4
        Re:Message per second count for Mirth DB

        afterdark23 wrote:
        Wow!! Switching to a PostgreSQL DB is like a night and day difference.

        Is there a particular reason that there is a monumental difference between DB performance when using them for the Mirth database?
        PostgreSQL is faster because it was built by Chuck Norris to record all of his facts! :woohoo:

        There are lots of reasons, Google for: postgres performance vs other databases for a few rough comparisons.

        My team is using Postgres almost exclusively now because its been consistently easier to install, easier to maintain and usually faster than the other options. The only places where we aren't using it is when we deploy our own applications or Mirth to a server that already has access to another database (usually SQL Server) or when we're working with a customer thats big enough to genuinely need Oracle.
        Jon Bartels

        Zen is hiring!!!!
        http://consultzen.com/careers/
        Talented healthcare IT professionals wanted. Engineers to sales to management.
        Good benefits, great working environment, genuinely interesting work.

        Comment


        • #5
          Re:Message per second count for Mirth DB

          PostgreSQL is faster because it was built by Chuck Norris to record all of his facts!
          lol. i left the door wide open for that one.

          but knowing the Chuck Norris built PostgreSQL, I can now turn all of our SQL Server databases over to PostgreSQL and now have to worry about any hackers.
          Reid Hospital and Healthcare

          Comment


          • #6
            Re:Message per second count for Mirth DB

            LOL how funny... SQL Server and MySQL IMO are jokes for real environments that actually have a heavy load. I don't get why EVERYONE builds their infrastructure around SQL Server. And, this is coming from someone who loves M$.
            Brendan Haverlock | Mirth Software Engineer | Mirth Corporation

            Comment

            Working...
            X