Viewing a response to: @justyy/re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t143614370z
Hey @justyy, thanks for your comment. I have regular contacts with @stoodkev about his great SteemPlus Chrome add-on and its usage of SteemSQL. We already talked together about "proxy risk" of publicly exposing API and this something @stoodkev perfectly understand. > you are missing a (NOLOCK) which might impose load to the steemsql server As explained in [this post](https://steemit.com/steemsql/@arcange/steemsql-update-12-about-locks-and-performances), the NOLOCK hint is no more required. > making assumptions that the ID increases as the timestamp increases. This is partially correct. ID indeed increase over time as it is an autonumber column. Anyway, should I implement non-linear blocks processing to improve performances, this assumption would become false.
author | arcange |
---|---|
permlink | re-justyy-re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t162005880z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"users":["justyy","stoodkev"],"links":["https://steemit.com/steemsql/@arcange/steemsql-update-12-about-locks-and-performances"],"app":"steemit/0.1"} |
created | 2018-04-23 16:20:06 |
last_update | 2018-04-23 16:20:06 |
depth | 2 |
children | 1 |
last_payout | 2018-04-30 16:20:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 774 |
author_reputation | 1,146,606,601,469,178 |
root_title | "Additional endpoints for SteemPlus backend" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 51,707,822 |
net_rshares | 0 |
Thanks for taking the time to help us improve these queries!
author | stoodkev |
---|---|
permlink | re-arcange-re-justyy-re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t172139277z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"app":"steemit/0.1"} |
created | 2018-04-23 17:21:39 |
last_update | 2018-04-23 17:21:39 |
depth | 3 |
children | 0 |
last_payout | 2018-04-30 17:21:39 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 60 |
author_reputation | 190,232,841,750,255 |
root_title | "Additional endpoints for SteemPlus backend" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 51,716,787 |
net_rshares | 0 |