search

OHDSI / Penelope

PENELOPE (Personalized Exploratory Navigation and Evaluation for Labels Of Product Effects) [under development]
Apache License 2.0
4 stars 2 forks source link

ACHILLES webAPI calls seem slower than HERACLES calls #34

Closed pbr6cornell closed 9 years ago

pbr6cornell commented 9 years ago

Can we make sure we have ACHILLES_results indexed appropriately

pbr6cornell commented 9 years ago

I added indexes to ACHILLES tables, and now everything's pretty fast

anthonysena commented 9 years ago

Was just looking into this as well based on a note that @leeevans made on the WebAPI issue list:

https://github.com/OHDSI/WebAPI/issues/66

Was looking at the indicies and saw that your indexing analysis_id and stratum_1 on ACHILLES_result. We may want to consider another index that includes stratum_2 since that is also used in the getDrugEraPrevalenceByGenderAgeYear.sql query: https://github.com/OHDSI/WebAPI/blob/master/src/main/resources/resources/cdmresults/sql/getDrugEraPrevalenceByGenderAgeYear.sql