Does Database Designer have a maximum number of queries?

Jeff_Cowan

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".

[Deleted User]

I 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

Navin_C

Hi 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