I was noticing frequent DB resyncs, and the root cause is that the 'sessions' table is constantly being updated, despite nothing in the data actually changing. I believe this is coming from the UI;
Normally, using Database->insert_or_update_sessions should handle not actually updating the DB unless something has changed. If this is not being used and the DB is being written to directly, a check needs to be made to only update if something has actually changed. The update rate is about 1/sec so the DB will grow quickly at this rate.
Marking this as 'high' as I believe I can mitigate this on the backend for now. If not, this is urgent.
I was noticing frequent DB resyncs, and the root cause is that the 'sessions' table is constantly being updated, despite nothing in the data actually changing. I believe this is coming from the UI;
Wait a few seconds;
Normally, using
Database->insert_or_update_sessions
should handle not actually updating the DB unless something has changed. If this is not being used and the DB is being written to directly, a check needs to be made to only update if something has actually changed. The update rate is about 1/sec so the DB will grow quickly at this rate.Marking this as 'high' as I believe I can mitigate this on the backend for now. If not, this is urgent.