[CORE-389] Totalnum performance improvements Created: 12/Mar/20  Updated: 25/Feb/21

Status: In Progress
Project: i2b2 Core Software
Component/s: None
Affects Version/s: 1.7.12
Fix Version/s: 1.7.13, 1.7.12a

Type: Improvement Priority: Major
Reporter: Jeffrey Klann Assignee: Jeffrey Klann
Resolution: Unresolved Votes: 0
Labels: None
Σ Remaining Estimate: Not Specified Remaining Estimate: Not Specified
Σ Time Spent: Not Specified Time Spent: Not Specified
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Sub-Tasks:
Key
Summary
Type
Status
Assignee
CORE-394 Create obfuscated reporting tables Sub-Task New  
CORE-398 Totalnum counter: support for multipl... Sub-Task New  
CORE-400 Show totalnums in top-level folders Sub-Task Resolved Reeta Metta  
Rank: 0|s000e0:
Participant/s:

 Description   
Totalnum counter performance is unacceptable on very large (>1.5million) element ontologies such as the ACT Medications ontology. Even smaller but very deep ontologies fail to compute on MSSQL and Oracle. Also, we plan to add some additional debug messages.

 Comments   
Comment by Jeffrey Klann [ 24/Apr/20 ]
1.7.12a has performance improvements in Postgres and MSSQL. Oracle improvements still forthcoming.
Generated at Sat Oct 23 14:15:31 UTC 2021 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.