Question on efficiency... If I have an app with a large table stored in Google Cloud SQL, then have a few smaller tables for the app (Users, etc.) that could easily go into an Appsheet DB (and would absolutely be easier to manage/update in AppSheet DB).
Knowing that I need to keep the large table in Cloud SQL, is it more or less efficient (or perhaps makes no difference) performance wise to store the other data in AppSheet DBs. Would the data sources be accessed in parallel and thus the large cloud SQL table will always be the bottleneck, or am I adding more overhead with the second data source type (appSheet DB)?
Tagging @ShirleyN since she is the Appsheet DB guru.
LinkedIn
Twitter
