RE: Improve the query with 'CONTAINS' and 'depth' 用这条指令来大幅度提高 SteemSQL 的查询性能 by trisolaran

cn · @trisolaran · Jun 11 '18 (edited)

$0.18

upvoted for arcange = 阿灿

`post_id`	52,607,071
`author`	trisolaran
`permlink`	re-dapeng-improve-the-query-with-contains-and-depth-steemsql-20180611t130309675z
`category`	cn
`json_metadata`	"{"app": "steemit/0.1", "tags": ["cn"]}"
`created`	2018-06-11 13:03:09
`last_update`	2018-06-11 13:03:21
`depth`	1
`children`	3
`net_rshares`	0
`last_payout`	2018-06-18 13:03:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.164 SBD
`curator_payout_value`	0.014 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	24
`author_reputation`	1,533,047,303,368
`root_title`	"Improve the query with 'CONTAINS' and 'depth' 用这条指令来大幅度提高 SteemSQL 的查询性能"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

哥！

`post_id`	52,607,367
`author`	dapeng
`permlink`	re-trisolaran-re-dapeng-improve-the-query-with-contains-and-depth-steemsql-20180611t130539586z
`category`	cn
`json_metadata`	"{"app": "steemit/0.1", "tags": ["cn"]}"
`created`	2018-06-11 13:05:39
`last_update`	2018-06-11 13:05:39
`depth`	2
`children`	1
`net_rshares`	0
`last_payout`	2018-06-18 13:05:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	2
`author_reputation`	64,235,894,740,263
`root_title`	"Improve the query with 'CONTAINS' and 'depth' 用这条指令来大幅度提高 SteemSQL 的查询性能"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

$0.06

没注意，还真自带一个“哥”

`post_id`	52,609,399
`author`	trisolaran
`permlink`	re-dapeng-re-trisolaran-re-dapeng-improve-the-query-with-contains-and-depth-steemsql-20180611t132335047z
`category`	cn
`json_metadata`	"{"app": "steemit/0.1", "tags": ["cn"]}"
`created`	2018-06-11 13:23:36
`last_update`	2018-06-11 13:23:36
`depth`	3
`children`	0
`net_rshares`	0
`last_payout`	2018-06-18 13:23:36
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.044 SBD
`curator_payout_value`	0.014 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	13
`author_reputation`	1,533,047,303,368
`root_title`	"Improve the query with 'CONTAINS' and 'depth' 用这条指令来大幅度提高 SteemSQL 的查询性能"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

非常感谢 🙇

`post_id`	52,608,661
`author`	arcange
`permlink`	re-trisolaran-re-dapeng-improve-the-query-with-contains-and-depth-steemsql-20180611t131654672z
`category`	cn
`json_metadata`	"{"app": "steemit/0.1", "tags": ["cn"]}"
`created`	2018-06-11 13:16:54
`last_update`	2018-06-11 13:16:54
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-06-18 13:16:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	6
`author_reputation`	231,443,210,169,699
`root_title`	"Improve the query with 'CONTAINS' and 'depth' 用这条指令来大幅度提高 SteemSQL 的查询性能"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000