hivemind icon indicating copy to clipboard operation
hivemind copied to clipboard

buffer notif writes

Open roadscape opened this issue 5 years ago • 0 comments

During sync, writes to hive_notifs writes should be queued and flushed.

INFO:hive.utils.stats:Service: db -- 224s total (71.1%)
INFO:hive.utils.stats:  -pct-     -ttl-     -avg-     -cnt-
INFO:hive.utils.stats:  21.0%   47018ms      1.79    26199x -- INSERT INTO hive_notifs (type_id, score, created_at, src_id, dst_id, post_id, communit ... S (:type_id, :score, :created_at, :src_id, :dst_id, :post_id, :community_id, :payload)
INFO:hive.utils.stats:  13.3%   29881ms      1.54    19344x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
INFO:hive.utils.stats:   9.4%   21068ms      1.37    15395x -- SELECT 1 FROM hive_notifs WHERE dst_id = :dst_id AND src_id = :src_id AND post_id = :post_id AND type_id = 17

roadscape avatar Sep 23 '19 13:09 roadscape