web stats
Database Reader and Performance Impact - Mirth Community

Go Back   Mirth Community > Mirth Connect > General Discussion

Thread Tools Display Modes
Old 06-14-2010, 06:29 AM
brmeyers brmeyers is offline
What's HL7?
Join Date: Feb 2010
Location: Nashville, TN
Posts: 5
brmeyers is on a distinguished road
Default Database Reader and Performance Impact

I'm interested in hear from others about their use of the database reader. With the reader polling the database, have you seen performance impact with your source system?
Reply With Quote
Old 06-16-2010, 05:26 AM
jbartels jbartels is offline
Mirth Guru
Join Date: Oct 2006
Posts: 725
jbartels is on a distinguished road

I can't say that I've ever seen a database slow down because of a reader, but there are some things to think through when you implement one:

1) Just like any other DB client, complex queries take longer and consume more resources
2) If you're polling the DB, consider polling on a VERY simple query that detects the need to pull data then running a secondary query (per message) that pulls the large amounts of data
3) Normal DB development rules apply, have your DBA review your queries and help you tune them, mind your joins and where clauses, etc. At the end of the day its just another DB client and Mirths impact all depends on what you are telling it to do.
Jon Bartels

Zen is hiring!!!!
Talented healthcare IT professionals wanted. Engineers to sales to management.
Good benefits, great working environment, genuinely interesting work.
Reply With Quote

database reader, performance

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 12:15 AM.

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