Realtime token usage
I have a table which 3 users need to edit in realtime. The process used to be a google sheet.
we have about 20 columns, and roughly 10 of them needs 2-5 updates per row, across 1500 rows a day.
My question is this. When we update a single cell, and send it from 1 user to 2 others, does the entire row, including all the columns, count as a realtime message, or is it just the one cell that was updated, which is being counted?
4 Replies
Are you using Postgres changes?
If not what method are you using.
If postgres_changes you get the entire row on each change.
I don't actually know what method it's using. I'm playing around with chatgpt codex so I don't really know what it's doing.
In any case, is what you're saying that if I update a cell in a row, with 20 columns, that counts as 1 realtime message + whomever many receivers?
I think Postgres_changes on database tables is just the ones subscribed to that table/filter getting messages. They will all get a message with the entire table row that changed for that one update. It could be though the database telling the realtime server counts as a message too, I don't recall if they call that out or not.
You are also using a term cell that is not a Postgres database term so not sure what you mean.
If you are sending messages on a channel to other users for what you are doing then it would be 1 send and then a receive for each user on the channel.
Thanks for your help - We'll try and do a live test and see how bad it gets. I'm hoping for sub 50k messages a day.