Hoping someone could perhaps advise on how Bubble handles the following
- Let’s say I have a “Unique Number” field for a Thing.
- A workflow will create a new record, with “Unique Number” field increasing by 1 . This is done by finding :max of the “Unique Number” field, then + 1.
- What happens when 100 users simultaneously triggers this workflow? Will Bubble’s backend be able to sequentially queue the records creation to guarantee “Unique Number” doesn’t duplicate?
Given the record creation processing time, theoretically, two concurrent user could receive the same :max of the “Unique Number” field, and as a result write two non-unique numbers to the “Unique Number” field. Does anyone know if Bubble’s backend already handles this concurrency situation?
Thanks for any input!