support in Room ? How many updates it could consistently reflect?
I have a fragment with recyclerview listening for realtime DB changes using
Flow<List<T>>
for a
select *
query and am performing ~10 writes/sec with
REPLACE
strategy, in the background. This results in dropping out some records (if there are 2 records in the list being updated frequently, they get merged into one, while having different values for primary key)
I'm not sure what exactly is a bottleneck here because SQLITE can easily handle these many writes.
