TxPath had successful tests with Postgres and Oracle. SQL server should work but not fully tested. Run times were <15 mins typically for 100K persons with 15-20 medications. I have cc’d the developer at Regenstrief Chen Wen to comment further.
Separately, Txpath-lite has been submitted as a pull request to WebAPI (https://github.com/OHDSI/WebAPI/pull/238) so hopefully will be accepted soon. The UI (which still needs lots of love from the community) can be found here. https://github.com/OHDSI/txPath-lite. Once the pull request is accepted, you should be able to begin evolving TxPath-lite to meet your needs. It is much faster, if simpler.