Hi all,
I’ve been working on a branch of Achilles that is intended to speed up performance of Achilles in MPP database platforms (Redshift and PDW) by utilizing multiple SQL sessions to run analyses that have no dependencies: https://github.com/OHDSI/Achilles/tree/multithreaded. Thus far, I’ve observed Achilles execution (without cost) that can take 1 or 2 hours on Redshift or PDW, compared to multiple hours using the older version.
I’m looking for help on testing with multiple dbms platforms, particularly those with Oracle, MySQL, Impala, or BigQuery expertise and access.
This version also brings us up to speed with CDM v5.0.1, meaning cost analyses are now possible.
Thanks,
Ajit