web stats
Mirth DB Reader\File Writer Writing One Message\Poll - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2014, 12:42 PM
akg2016 akg2016 is offline
Mirth Newb
 
Join Date: Feb 2014
Location: Philadelphia, PA
Posts: 6
akg2016 is on a distinguished road
Default Mirth DB Reader\File Writer Writing One Message\Poll

Hey All:

I've been using mirth for awhile..and encountered this strange error starting this week..
I am pulling from an external DB and writing to a simple .txt
I can't figure out what I've done to change the settings but every time Mirth polls and reads the database, it writes one message...then re-polls the entire database and writes another, one message per poll.
What it used to do was write the entire batch before a new poll (~2000 messages).

Any thoughts?
Thanks Much!

~Alex

Last edited by akg2016; 12-05-2014 at 12:44 PM.
Reply With Quote
  #2  
Old 12-09-2014, 05:15 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,246
cory_cole is on a distinguished road
Default

Which version of Mirth are you using?
Reply With Quote
  #3  
Old 12-09-2014, 09:47 AM
akg2016 akg2016 is offline
Mirth Newb
 
Join Date: Feb 2014
Location: Philadelphia, PA
Posts: 6
akg2016 is on a distinguished road
Default

I'm using Mirth 3.0.1.7051
Reply With Quote
  #4  
Old 12-09-2014, 10:13 AM
akg2016 akg2016 is offline
Mirth Newb
 
Join Date: Feb 2014
Location: Philadelphia, PA
Posts: 6
akg2016 is on a distinguished road
Default

I should probably be a little more specific
I generally have not had a problem pulling between 2k and 70k rows from a database table and writing them to a file. The speed was generally good.
When I had mirth pull from a table that has millions of records (even though I was still only pulling between 2k and 70k records, I restricted my query) the speed is abysmal....A message processed a minute, and I can't for the life of me figure out why.
Reply With Quote
  #5  
Old 12-09-2014, 12:38 PM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,246
cory_cole is on a distinguished road
Default

1) I would build some indexes to speed up the search results.
2) Cut and paste the query from mirth into the database and see what results you get. You may have limited it to the point that you are only get one message at a time.
Reply With Quote
  #6  
Old 12-10-2014, 04:23 AM
akg2016 akg2016 is offline
Mirth Newb
 
Join Date: Feb 2014
Location: Philadelphia, PA
Posts: 6
akg2016 is on a distinguished road
Default

I've built a couple indexes. When I run the query outside of Mirth it pulls the proper amount of records but it takes ~40 seconds.
Does Mirth have a upper time limit to which it can run a query?

Thank you so much for your help, by the way!
Reply With Quote
  #7  
Old 12-10-2014, 05:55 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,246
cory_cole is on a distinguished road
Default

Can you post your channel here?
Reply With Quote
  #8  
Old 12-10-2014, 07:04 AM
upstart33 upstart33 is offline
Mirth Guru
 
Join Date: Dec 2010
Location: Chicago, IL.
Posts: 459
upstart33 is on a distinguished road
Default

Do you have 'Append to file' selected on your Destination writer? And what are you using for your Destination File Name?
Reply With Quote
  #9  
Old 12-10-2014, 09:07 AM
akg2016 akg2016 is offline
Mirth Newb
 
Join Date: Feb 2014
Location: Philadelphia, PA
Posts: 6
akg2016 is on a distinguished road
Default

Yuppo I have "append to file "
I have attached the file.
Thank you all!
Attached Files
File Type: xml RadTest1.xml (36.2 KB, 31 views)
Reply With Quote
Reply

Tags
database, database reader, polling

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:18 PM.


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