Announcement

Collapse
No announcement yet.

Mirth DB Reader\File Writer Writing One Message\Poll

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

  • 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, 12:44 PM.

  • #2
    Which version of Mirth are you using?

    Comment


    • #3
      I'm using Mirth 3.0.1.7051

      Comment


      • #4
        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.

        Comment


        • #5
          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.

          Comment


          • #6
            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!

            Comment


            • #7
              Can you post your channel here?

              Comment


              • #8
                Do you have 'Append to file' selected on your Destination writer? And what are you using for your Destination File Name?

                Comment


                • #9
                  Yuppo I have "append to file "
                  I have attached the file.
                  Thank you all!
                  Attached Files

                  Comment

                  Working...
                  X