[Enquiry] What is the best way to add a number to another number in the database and why?

Hi, I want to keep a running total of how may sessions a user has. I can see several ways of doing this, and wondered what is the best.

option 1 (seems the worst?)
image

option 2 (seems ok?)
image

option 3 (seems convoluted, but might cost fewer WUs?)

  • I create a total number of sessions field in the User type
    image

Or is there another, better way of doing this?

Thanks!

I’ve always just used Option 3 :sweat_smile:

2 Likes