create account

RE: 请MSSQL高手指点一下JSON的问题 by powerfj

View this thread on: hive.blog |  peakd.com |  ecency.com

Viewing a response to: @oflyhigh/mssql-json

cn · @powerfj · 
用like的话, 如果数据量大的时候, 数据库应该要跪掉.. 如果要保证性能,  可能有索引最好
properties (22)
authorpowerfj
permlinkre-oflyhigh-mssql-json-20170815t162801055z
categorycn
json_metadata{"tags":["cn"],"app":"steemit/0.1"}
created2017-08-15 16:28:00
last_update2017-08-15 16:28:00
depth1
children0
last_payout2017-08-22 16:28:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length48
author_reputation1,712,765,353,203
root_title请MSSQL高手指点一下JSON的问题
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id11,895,216
net_rshares0
Help/Feedback