Major 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.
Attachments
1.
|
Create obfuscated reporting tables |
|
Closed | Jeffrey Klann |
2.
|
Totalnum counter: support for multiple fact tables |
|
In Review | Jeffrey Klann |
3.
|
Show totalnums in top-level folders |
|
Resolved | Reeta Metta |
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Jeffrey Klann [ jklann ] |
| Fix Version/s | 1.7.13 [ 10902 ] | |
| Fix Version/s | 1.7.12a [ 11008 ] |
| Status | New [ 10000 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
1.7.12a has performance improvements in Postgres and MSSQL. Oracle improvements still forthcoming.
Oracle, PGSQL, and MSSQL are all now on par with performance. MSSQL's most recent improvement, contributed by Darren Henderson, does not make sense in the architecture of the other scripts (it doesn't generate the same temp table).
This could be reopened in the future, as performance can always be improved.
This could be reopened in the future, as performance can always be improved.
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |