You are viewing a single comment's thread from:

RE: STEEMSQL - Update 9 - Performances improvement

in #steemsql7 years ago

Nice 👍🏼! I was wondering what the load time was on transactional data. Glad to hear SteemSQL is continuously improving.

Question: Are edits to posts triggering an update to the existing records?

Also, do you know the approximate load time for transaction made? i.e how frequent are loads?

Sort:  

Question: Are edits to posts triggering an update to the existing records?

Each edit generate an insert of a new record in TxComments and an update in Comments

how frequent are loads?

SteemSQL process new blocks every 10 seconds.
Accounts and Comments are updated every 10 minutes