Right, what is the largest data base run on knack? Any ideas, how far I can I push this till we have to build our own platform?
Also a big shout out for knack today on a podcast I was interviewed for: https://open.spotify.com/episode/7n7VKesn3IDE5VnCkFaTrB?si=JHf9B3wKTVCQmcWni3IDfQ
Interested to know how many GB or records total can be built with knack
Ben
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.
do you know what size in gb? or terrabytes?
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.
Isn’t that 500GB the storage allowed in that plan? Not the size of the db? Maybe I misunderstood the question.
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.