Hey Ben, I know of users who have millions of records. It all comes down to how optimised your tables are, and ensuring there aren’t too many heavy calculations going on.
Also nice work on the podcast episode! It was interesting to hear how you utilised Knack.
The Plus 3 plan goes up to 500GB, and I’m sure you can get additional storage, but I’m not sure what impact it would have on performance. You’d probably experience the same issue if you built in a separate platform.
One of my clients has had a database with 2.5M records - it was a little slow but mainly because there were a lot of connections to user account records and also calculations.
Their current system has 630,000 records in 325 tables with about 55 user roles. This is pushing the maximum schema size (complexity) for a Knack app and is a bit slow - mainly due again to the sheer number of calculations and connections to the Users table I think.
In conclusion, Knack has a pretty high capacity but can be slow if it get’s too complex.