[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 |