web stats
Database Reader and Performance Impact - Mirth Community

Go Back   Mirth Community > Mirth Connect > General Discussion

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 06-16-2010, 05:26 AM
jbartels jbartels is offline
Mirth Guru
 
Join Date: Oct 2006
Posts: 722
jbartels is on a distinguished road
Default

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!!!!
http://consultzen.com/careers/
Talented healthcare IT professionals wanted. Engineers to sales to management.
Good benefits, great working environment, genuinely interesting work.
Reply With Quote
Reply

Tags
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 04:00 AM.


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