KX Community

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

Home Forums KX Solutions Dashboards Streaming (For Dummies)

  • Dashboards Streaming (For Dummies)

    Posted by Laura on March 31, 2023 at 12:00 am

    Talk to me as if Im a small child, or a Labrador retriever.

    I have a Tickerplant. Subprocesses connected to the tp.

    My subprocesses crunch some data and then update columns on a localized master table.

    – Localized as in: local to that subprocess.

    I’ve reached a point where Dashboards takes prohibitively long to query my table.

    It dawned upon me, streaming.

    My question, what I need help with, is: what do I need to do to convert a table in a tp subprocesses to make it streaming so Dashboards can plot the data to a ChartGL for me?

    Many thanks.

    Laura replied 9 months, 2 weeks ago 2 Members · 2 Replies
  • 2 Replies
  • rocuinneagain

    Member
    March 31, 2023 at 12:00 am

    For KX Platform Dashboards on the backend follow:

    The UI options** are covered on:

    https://code.kx.com/dashboards/datasources/#streaming

    (**as well as backend if instead using Dashboards Direct)

     

  • Laura

    Administrator
    March 31, 2023 at 12:00 am

    Hey Roc,

    Thanks. Don’t think the Platform stuff is going to fit the bill given I already have a backend with the TP stuff going on.

    I’ve been working off the UI options, since Im using Dashboards, and have managed to get data streaming in but it appears to stop after 20-30 seconds.

     

    Do I need to add anything to the TP sym.q file?

    Once I’ve added the:

    .u.snap:{tablename}

    .ringBuffer.read:{[t;i] $[i<=count t; i#t;i rotate t]};
    .ringBuffer.write:{[t;r;i] @[t;(i mod count value t)+til 1;:;r];};
    .stream.i:0-1;
    .stream.tablename:20000#tablename;

    Is there any other requisite to stream data into Dashboards?

Log in to reply.