KX Community

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

Home Forums kdb+ Large Scale WindowJoins Questions Re: Large Scale WindowJoins Questions

  • rocuinneagain

    Member
    December 1, 2022 at 12:00 am

    On my laptop this took 765 milliseconds – what runtime are you seeing?

    data:([] dt:`s#.z.p+0D00:00:01*til 800000;mmm3:800000?1000.0) 
    f:`dt; w:(-1000000; 0)+:data[`dt]; 
    \ts result: wj[w;f;data;(data;(max;`mmm3);(min;`mmm3))]