Hi,
I was learning about data partitions for scaling. I have a doubt In which partition new record is added ?
Lets have a scenario , all partitions from different sources.
It selects the partition you are using at that moment. You can only use one partition at the same time.
I’ve not used partitions. What happens if you add a row that doesn’t fit in the partition criteria?
When the all partition matches the criteria and data is pulled from all partitions to a particular user. Then which partition is used to write the data? How it is being selected?
You can’t read data from all partitions. When you are using partition, you select one of your data sources with a formula and for that reason, only one source is available at the same time.
2 Likes
What kind of case are you thinking? Remember the formula with the partition is not based on rows.
1 Like
So, it is also not possible to read all data from all partitions. Right ?
If the user wishes to see the data from all partition what is the method for it ?
The user needs to select the correct partition dynamically from the app.. for example selecting it from the Users table etc. But the user is able to see only one partition at the same time.
1 Like
Right, not based on rows. My thinking was wrong. Nevermind!