You are viewing a single comment's thread from:

RE: STEEMSQL - Update 9 - Performances improvement

in #steemsql • 8 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?

8 years ago in #steemsql by
100%
    -100%

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      0.00 ARCHON
        Reply 1
        Sort:  
      • Trending
        • [-]
         8 years ago 

        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

        100%
          -100%

            Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

            • Disagreement on rewards
            • Fraud or plagiarism
            • Hate speech or trolling
            • Miscategorized content or spam

            Submit
            0.00 ARCHON
              Reply