Glitch Posted March 21, 2019 Report Share Posted March 21, 2019 Hi! How many tables can I join in my View? If I have 20 tables joined in my view, would that affect the performance of my application? Quote Link to comment Share on other sites More sharing options...
0 ManokNaPula Posted March 21, 2019 Report Share Posted March 21, 2019 Hi @Glitch This was in the Caspio documentation. You can use up to 16 tables, but best performance should be less than that. ❤️ Quote Link to comment Share on other sites More sharing options...
0 JolliBeng Posted March 22, 2019 Report Share Posted March 22, 2019 Hi, I suggest that you normalize your tables first. Make sure that the tables are well-architected accordingly to the needs of yourapplication. Introduction to Table and Table Design Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU -JolliBeng Quote Link to comment Share on other sites More sharing options...
Question
Glitch
Hi!
How many tables can I join in my View? If I have 20 tables joined in my view, would that affect the performance of my application?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.