How deep is too deep for relationships( e.g 4-6 levels)

Question

As an app developer or designer building multi-table workflows, I want to know the safe limit for relationship depth so that I can avoid overly nested structures that make reports slow, formula unreliable and also hard to maintain the app

MarkShnierYou · Answer

Quickbase is optimized for complexity and flexibility. The main design goal should be the user experience and what the app needs to do,  and less so worrying about the complexity of the app.  Quickbase is really Quick. it loads the whole App's data into memory.  I have apps with hundreds of tables, about 100 users,  and deeply nested relationships.  If you avoid using Formula Queries (a particular type of formula syntax) it should perform just fine.  I would be happy to jump on a quick call with you if you like me to take a quick look at your app.  mark.shnier@gmail.com

Sign up

Login to the community