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.

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

Replace INSERT INTO SQL statements with SELECT INTO statements for increased speed #18

Open
schuemie opened this issue Jan 27, 2020 · 0 comments
Labels
enhancement New functionality that could be added

Comments

@schuemie
Copy link
Member

On MPP database platforms, INSERT INTO statements as used here are extremely slow. We should use SELECT INTO statements, creating several temp tables, and merging them into the final temp table using another SELECT INTO. This will be several orders of magnitude faster on some platforms.

@schuemie schuemie added the enhancement New functionality that could be added label Jul 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New functionality that could be added
Projects
None yet
Development

No branches or pull requests

1 participant