Page History
...
- Must be tested
- Must include unit tests (for new features)
- Must include documentation (can be part of the pull request)
Tips for Optimizing i2b2 query speed
- Do not use '%' in any concept code. In Postgres, this is known to prevent the database from using indexes.
- In Postgres, consider using table partitioning
- If your fact table is extremely large, consider splitting it into multiple fact tables.
- ... more to come...