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 2, 2022 at 12:00 am

    I added extra columns and it did not slow down the operation for me.
    Is your data in memory or on disk?

    data:([] dt:`s#.z.p+0D00:00:01*til 800000;mmm3:800000?1000.0) 
    data:data,'flip (`$"col",/:string til 30)!30#enlist til 800000 
    f:`dt; w:(-1000000; 0)+:data[`dt]; 
    result: wj[w;f;data;(data;(max;`mmm3);(min;`mmm3))]