Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Investigate performance of CreateVocabMapTables() #151

Open
AnthonyMolinaro opened this issue Dec 7, 2022 · 0 comments
Open

Investigate performance of CreateVocabMapTables() #151

AnthonyMolinaro opened this issue Dec 7, 2022 · 0 comments
Assignees
@AnthonyMolinaro
Labels
enhancement New feature or request

Comments

@AnthonyMolinaro
Copy link
Contributor

See if we can improve the performance of create_source_to_standard_vocab_map.sql and create_source_to_source_vocab_map.sql
Given the recent optimization in ATLAS generated cohort sql, the step 1 would be to replace CTEs with temp tables.
@AnthonyMolinaro AnthonyMolinaro self-assigned this Dec 7, 2022
@AnthonyMolinaro AnthonyMolinaro added the enhancement New feature or request label Dec 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@AnthonyMolinaro AnthonyMolinaro

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@AnthonyMolinaro