Forum Discussion

Roy-Wanyoike's avatar
Roy-Wanyoike
Qrew Captain
1 month ago

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

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

4 Replies

  • 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.  [email protected]

    • Roy-Wanyoike's avatar
      Roy-Wanyoike
      Qrew Captain

      This is helpful—especially the reassurance around deeply nested relationships.

      I’m curious though: even if Quickbase can technically handle deep relationship chains, do you have personal design thresholds where you intentionally stop adding more layers for maintainability reasons?

      For example, beyond performance, have you found a point where debugging formulas, tracing lookups, onboarding new builders, or modifying workflows becomes noticeably harder (e.g., after 4–6 relationship levels or certain dependency patterns)? Also, could you expand a bit on why avoiding Formula Queries helps in deeply nested apps, and what alternatives you typically use instead?

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Well, this is funny, but maybe actually not funny at all.  

        I'm starting to feel like I've been phished into a conversation with a Chinese AI bot to train their AI. Please contact me through this Forum or via the email address. I believe I previously provided and will set up a Zoom call for a proper conversation where I can see if you are a real person.