KX Community

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

Home Forums kdb+ Question on sorting a large partitioned table

  • Question on sorting a large partitioned table

    Posted by jackyyuk on December 4, 2023 at 12:00 am

    Hello,

    Currently, I would like to sort a partitioned table by its column colA and colB. I simple perform the following actions:

    { t:`colA`colB xasc select from `:<dir_source>/<date>/<trade>;

    (`:<dir_destination>/<date>/<trade>;17;2;6) set t} for each dates

    However, the q service was killed occasionally due to memory usage, as some the table data is very large.

    Is there anyway to reduce the memory usage, and prevent the killing?

     

    Thanks,

    Jacky

    jackyyuk replied 3 months, 1 week ago 2 Members · 1 Reply
  • 1 Reply

Log in to reply.