Daljeet Virdi
CCConvex Community
•Created by Daljeet Virdi on 3/26/2025 in #support-community
can multiple workers safely update different rows in a table concurrently
Thank you for helping me with this. Hope to have something for #show-and-tell in a couple weeks!
12 replies
CCConvex Community
•Created by Daljeet Virdi on 3/26/2025 in #support-community
can multiple workers safely update different rows in a table concurrently
So the optimal option is to stream and batch update to the database
12 replies
CCConvex Community
•Created by Daljeet Virdi on 3/26/2025 in #support-community
can multiple workers safely update different rows in a table concurrently
Perfect!
12 replies
CCConvex Community
•Created by Daljeet Virdi on 3/26/2025 in #support-community
can multiple workers safely update different rows in a table concurrently
12 replies
CCConvex Community
•Created by Daljeet Virdi on 3/26/2025 in #support-community
can multiple workers safely update different rows in a table concurrently
I’m streaming an AI response and updating the same row in the database every ~50ms. I’m wondering if that’s the right approach for a streaming workload.
Would it be more appropriate to insert new rows for each stream update instead of continuously updating the same record? I’m concerned that this would cause the table to grow quickly, but I could periodically move older rows to an archive table via a batch job if that’s the better pattern.
I understand Convex uses optimistic concurrency control, not locks. Still, I’m seeing symptoms like retries and delays - see screenot. Any tips on how to better handle concurrent updates in this scenario?
Thanks!
12 replies