RE: MySBDS - Steem Blockchain Data Service in MySQL

You are viewing a single comment's thread from:

MySBDS - Steem Blockchain Data Service in MySQL

in utopian-io •  7 years ago 

I've been asking myself this exact same question as well, your approach just may work. I'll definitely post if I find some answers.

utopian-io
7 years ago by

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.77
  • Past Payouts $0.77
  • - Author $0.58
  • - Curators $0.19
1 vote
2
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
  • Trending
    • [-]
      ·  7 years ago 

    Another thing that may be worth considering is that the comments table is the second biggest in storage space, and it may be worthwhile to save space removing removing older edited versions of the "body" mediumtext entries. For example, sometimes I edit a big long post a few times to correct a few typos and this type of editing may be fairly common and may be able to reduce the database size a lot.

    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.69
    • Past Payouts $0.69
    • - Author $0.69
    • - Curators $0.00
    1 vote
    [-]
      ·  7 years ago 

    Yeah, great point! The body is fully duplicated on edits so that really could save some significant space.

    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