[CORE-313] CRC-PDO: AverageObservationPageMethod doesnt work Created: 23/Aug/18  Updated: 16/Mar/20

Status: Reopened
Project: i2b2 Core Software
Component/s: None
Affects Version/s: None
Fix Version/s: TBD

Type: Bug Priority: Major
Reporter: Lori Phillips Assignee: Mike Mendis
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i0041r:
Developer Notes: The way to test this is to
1. Modify the crc properties file to use
# Paging method can be SUBDIVIDE_INPUT_METHOD/AVERAGE_OBSERVATION_METHOD
edu.harvard.i2b2.crc.pdo.paging.method=AVERAGE_OBSERVATION_METHOD

2. Request a PDO using a large data set that exceeds the observation fact page size of 5000. This method will converge on a page size much faster than the SUBDIVIDE method
Server Plug-in/s Modified:
edu.harvard.i2b2.crc
Participant/s:

 Description   
This method was converging on a page size that was over the page size limit. Fix was to alter the algorithm.

 Comments   
Comment by Reeta Metta [ 24/Jan/19 ]
needs to be fixed for SQL server and PostgreSQL
Comment by Reeta Metta [ 25/Sep/19 ]
check for performance with large PDO set
Comment by Reeta Metta [ 01/Oct/19 ]
Oracle - 5K patientlist took 9.79seconds
SQLServer took 45 seconds
PostGresSQL timedout after 45 seconds with java.netsocketTimeoutException
Generated at Sun Sep 27 13:45:21 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.