Many thanks @benwilson512.
I think the option two will work for me.
It’s a high traffic application, using Elixir and ecto_sql with postgres.
There is usually multiples of requests to the same account.
For each request, I need to reduce the account balance by the requested value before taking an action, hence the need to do read, modify, and write on the record.
Kindly let me try it out and feedback on the outcome.
Regards,
Jerry
