DX NetOps

 View Only
  • 1.  How to distribute the load for OData Query? Is it possible?

    Posted Apr 09, 2021 09:03 AM
    Hello

    Is it possible to distribute the load from OData API Queries to the Data aggregator? (is it possible to use a backup DA for this, for example?)

    Any strategies that you advise to optimize the load that API queries do to the system?

    Thank you.

    BR
    Bruno Sousa


  • 2.  RE: How to distribute the load for OData Query? Is it possible?

    Broadcom Employee
    Posted Apr 09, 2021 11:54 AM
    95% of the work odata does is SQL queries to the vertica DB.

    The config only allows 4 odata calls to run at once.  The rest are queued and processed as the current 4 complete.
    If that doesn't seem to be enough, that can be increased, depending on vertica specs and how long current queries take to run.  And you'd want to make sure the additional queries in vertica don't effect other queries like reporting/thresholding/etc.


  • 3.  RE: How to distribute the load for OData Query? Is it possible?

    Posted Apr 12, 2021 05:15 AM
    Hello Jeffrey,

    Thank you for the feedback!

    Maybe my question was not clear though...  my question is if it is possible to direct the OData Queries for a second instance of a Data Agreggator or something similar?

    Is it somehow possible to release some load from the main Data Aggregator that is already dealing with all the polling and threshold data from the API request processing?

    Thank you.

    BR
    Bruno Sousa


  • 4.  RE: How to distribute the load for OData Query? Is it possible?

    Posted Apr 12, 2021 05:23 AM
    The short answer is no, that is not possible.

    ------------------------------
    Senior Consultant
    SolvIT Networks
    ------------------------------