Skip to content

adding warehouses to existing db? #219

Answered by sm-shaw
SQLAmanda asked this question in Q&A
Discussion options

You must be logged in to vote

Yes it is possible and would involve saving and then modifying a custom build script. However, it would be best to address the core issue as to why it is taking so long to load the schema instead. As a guide using MySQL we see loading 1000 warehouses takes 10 minutes. It will load in parallel depending on how many virtual users you have created to do the build.
So the key question is why is it taking so long to load? - in the cloud addressing the network round trip is important, if however as you say the client is in the same cloud as the database then this shouldn't necessarily be an issue (but please verify this). If you are sure it's not the network round trip then another key area is …

Replies: 1 comment 3 replies

Comment options

You must be logged in to vote
3 replies
@SQLAmanda
Comment options

@SQLAmanda
Comment options

@sm-shaw
Comment options

Answer selected by SQLAmanda
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants