About 1.5 million messages are processed every day.
This phenomenon only occurs during peak business periods and is more normal during business downturns.
Does this mean that some configuration adjustments to the router are needed to improve its processing power?

HisEmrRouter's number of job: 10

ADT RoutingRule number of job: 5

Tks

About 1.5 million messages are processed every day.
This phenomenon only occurs during peak business periods and is more normal during business downturns.
Does this mean that some configuration adjustments to the router are needed to improve its processing power?

HisEmrRouter's number of job: 10

ADT RoutingRule number of job: 5

Tks

Maybe you are right. So what's the limit of iris community?

Tks

Yes, I did it in System Management portal, How to find the sql query process? 

I need pick bussiness field from message body on more high level , I don't want to modify every process logic.

And if the business service is builtIn process not custom process.  for example:

EnsLib.HL7.Service.TCPService -> EnsLib.HL7.Operation.TCPOperation

above flow will insert hl7 request and response to table EnsLib_HL7.Message and other message tables. 

I want to get message body to parse it before insert.

But The EnsLib.HL7.Service.TCPService   and EnsLib.HL7.Operation.TCPOperation is builtIn .

So I think ensembe is provide some hook like before and after

EnsLib.HL7.Service.TCPService ->before hook ->sendSync->After hook-> EnsLib.HL7.Operation.TCPOperation

Thank You.

I tryed ROW_NUMBER() ,got follow error:

Mistake in SQL statement, ERROR #5540: SQLCODE: -359 Message: User defined SQL function 'SQLUSER.ROW_NUMBER' does not exist

The problem is not what I use either ROW_NUMBER() or ROW_NUM fake field.

The point is the flow .Cache first find ROW_NUMBER() in self platform but platform not contain oracle function.

Or is it platform's limit?  I don't know where is the border..

Thank You,