OHMPI 2.0 - Simple Patient Loookup Search Is Slow For LID Merged Records

(Doc ID 2179721.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Healthcare Master Person Index - Version 2.0.9 and later
Information in this document applies to any platform.


On : 2.0.9 version, Master Index Main Component

When performing a Simple Patient Loookup on records which have been merged, performance is slow compared to records without any merges.

for example:

Better response for the records which have been merged.

The issue can be reproduced at will with the following steps:

1) Setup PersonTest Project

2) executeMatch for all five records

3) mergeSystemRecord, merging LID 0000000002 into 0000000001

4) mergeSystemRecord, merging LID 0000000003 into 0000000001

5) mergeSystemRecord, merging LID 0000000004 into 0000000001

6) Perform a Simple Patient Lookup on EUID: 0000000000

7) Check number of SQL statements

8) Rotate Server log in OHMPI Admin Console

9) Remove old server logs

10) Perform a Simple Patient Lookup on the EUID with merged: 0000000019

11) Check number of SQL statements

Total number of SQL Statements: = 343


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms