You are viewing a single comment's thread from:

RE: SteemSQL - Database updated and ready for SMTs

in #steemsql • 5 years ago (edited)

Great!

cast(left(a.vesting_shares, len(vesting_shares)-6) as float)*RATE/1000000

will soon be

vesting_shares*RATE/1000000

A little easier to read and a bit quicker, although I'm sure it's not the bottleneck in most of my queries ;)

5 years ago in #steemsql by
$0.00
    2 votes
    Reply 1
    Sort:  
  • Trending
    • [-]
     5 years ago (edited) 

    Something like that, yeah =)

    BTW, you shouldn't underestimate string manipulation overhead when you apply it to thousands or millions of rows.