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

Feature Request: improve ApplySchema multi-query performance in direct strategy #13692

Closed
shlomi-noach opened this issue Aug 3, 2023 · 0 comments · Fixed by #13693
Closed

Comments

@shlomi-noach
Copy link
Contributor

Feature Description

When ApplySchema is supplied with multiple queries, it runs a per-query loop that applies each query onto the shards. With direct strategy, we just run ExecuteFetchAsDBA.

A common scenario is when you want to bootstrap a new shard/cluster with a known schema. In that scenario, one may need to apply thousands of CREATE TABLE|VIEW statements onto the shards. Applying those one-at-a-time takes a significant toll due do network overhead.

We want to improve this performance.,

Use Case(s)

Populating new large schemas on empty shards.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant