Qrew LegendQuickbase actually does a great job of performing even in a complex app with hundred of tables and many summary and lookup fields. As long as you actually don't have circular relationships, it will all work. If you have reports which rely on complex summary fields, the report might take a second or two longer to load.
Can you give us some idea of the record counts in these tables? If yoou are dealing with under 250,000 "ish" records per table, then there is usually no performance issues. Once you get into like a million records, then you may start to see performance issues or actually hit table size limits of 500 MB if you have many many scalar (data entry) fields.
Thanks for the insight. That’s reassuring to hear that Quickbase can still perform well even with high table counts and many lookups/summaries as long as the relationships are structured properly.
I’m curious about where performance issues tend to show up first in real-world apps. In your experience, is the bigger bottleneck usually:
Also, beyond avoiding circular relationships, are there any relationship design patterns or anti-patterns you recommend for keeping large apps maintainable over time?
