KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ Something for the weekend? Re: Something for the weekend?

  • jfealy

    Member
    March 19, 2024 at 11:00 am

    Masking is nice but as an alternative & still taking care not to remove leading blanks

    q){x where 1b,1_not” “~’:x}s:” the quick brown fox ” ” the quick brown fox ”

    Appears to be faster

    q)S:10000000#s 
    q)ts:5 {x where not n&prev n:null x}S 
    197 100663904 
    q)ts:5 {x where 1b,1_not" "~':x}S 
    147 83886816

    caching taking place?

    q)ts:5 {x where not n&prev n:null x}S 
    144 100663904 
    q)ts:5 {x where 1b,1_not" "~':x}S 
    148 83886816