web stats
Performance problems on Mirth 3.4.2.8129 while searching messages without filtering - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2018, 10:57 PM
fmonmen fmonmen is offline
What's HL7?
 
Join Date: May 2018
Posts: 1
fmonmen is on a distinguished road
Default Performance problems on Mirth 3.4.2.8129 while searching messages without filtering

Hi,

First of all, thanks to all of you for helping people with theirs problems.

I have decided to write here because i had search a lot on the web but i didn't find anything.

Me and my work team have problems with a channel that receive a lot of messages and with a high size (ORU messages). The problem is caused on the BBDD server when someone makes a search on this channel, at the dashboard, and you don't add filters. This kind of search cause problems and we are seaching a way that we can put a filter by default (only today messages ex.) to this channel, or to all of them if it's not possible to add only to an specific channel.

The query is
Code:
SELECT MESSAGE_ID AS MESSAGE_ID, METADATA_ID AS METADATA_ID, CONTENT_TYPE AS CONTENT_TYPE       FROM D_MC562       WHERE MESSAGE_ID  >=   @P0              AND MESSAGE_ID  <=   @P1                      AND CONTENT LIKE '%' +  @P2  + '%'
This channel has "prune content" activated with 30 days.

Thanks to all of you. Regards
Reply With Quote
  #2  
Old 05-16-2018, 05:59 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 275
AlexNeiva is on a distinguished road
Default

Hello,

why don't you use METADATA variables?
You can add one or two metadatas and on Mirth search you can go by those metadatas and by a date range.
You will see that is a lot faster.
__________________
Best Regards,
Alex Neiva
Reply With Quote
  #3  
Old 05-16-2018, 09:51 AM
siddharth siddharth is offline
Mirth Guru
 
Join Date: Feb 2013
Posts: 832
siddharth is on a distinguished road
Default

yeah but they still have to go in advanced search and include metadata in search...
__________________
HL7v2.7 Certified Control Specialist!
Reply With Quote
  #4  
Old 05-17-2018, 02:35 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 275
AlexNeiva is on a distinguished road
Default

So from my understanding, when he double clicks on the channel just to see the messages by default it "crashes"?
What he want is when double clicks the channels, by default only show the messages received today?
__________________
Best Regards,
Alex Neiva
Reply With Quote
  #5  
Old 05-17-2018, 05:09 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 554
kirbykn2 is on a distinguished road
Default

What is the message size and volume? What is the server configuration (memory, cpus, disk, etc)
__________________
Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.2
Mirth Connect Version 3.6.1
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_121-b13
PostgreSQL Version 9.6.3
Reply With Quote
Reply

Tags
blocks, dashboard, filtering, heavy channel, 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:08 AM.


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