I have 2 data sets partitioned between 4 teams. They are 17,000 and 10,000 rows respectively x4.
Last night I tested sync times for using a partition. I also tested sync times for using a slice where I joined all partitions into one data set, and slice filtered each team’s data.
I also experimented with no partitions and just using app as if the other 4 teams didn’t exist. Just one copy of both data sets.
Having all team’s data in one sheet and using a slice allowed instant no sync switching between each team. But sync time was around 30 seconds sometimes more… Which is still impressive for that much data in my opinion…
Using partitions was cumbersome as sync time was still around 20 seconds, and required sync for every time I switched team.
Removing teams, and having only one copy of each data set brought the sync time down to around 15 seconds. In this case to switch to another team, might be just having a button to redirect user to another app connected to that data.