Just wondering if there are a maximum number of queries I can provide to database designer in the "Queries" section? I tried uploading 200 queries for an incremental design and the designer just spins and spins saying "Loading".
Does Database Designer have a maximum number of queries?
+2I don't think that we have a maximum number. However, please note that it may take a long time to complete to proceed if you provide many queries once. We usually recommend that you limit the design input to 100 queries.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/GettingStartedGuide/Tutorial/Step5CreateAComprehensiveDesign.htm
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/GettingStartedGuide/Tutorial/Step5CreateAComprehensiveDesign.htm
+2Hi Jeff,
Before Vertica 6 version there was a hard limit for number of queries and it was 100 for the DBD.
After Vertica 6 this limit was raised and there is no such documented limit for the DBD.
Maybe you can check these tables from another sessions while DBD is going on.
design_status
design_queries
Hope this helps.
NC
Before Vertica 6 version there was a hard limit for number of queries and it was 100 for the DBD.
After Vertica 6 this limit was raised and there is no such documented limit for the DBD.
Maybe you can check these tables from another sessions while DBD is going on.
design_status
design_queries
Hope this helps.
NC
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
