time for data extraction for instrument prices by dss api

nimesh.jain
nimesh.jain Newcomer

i am trying to extract instrument prices for 50 instruments but it takes lot of time for output. almost 40-50 seconds.

Best Answer

  • Christiaan Meihsl
    Answer ✓

    @nimesh.jain, yes, if you increase the number of items you can expect the extraction time to increase. Extraction time depends on several parameters:

    • Number of items
    • Number of data fields
    • Date range of the query
    • Amount of data
    • Server load

    It is impossible to calculate the time for an extraction, it varies too much. I tried making the same query repeatedly and measuring the extraction time, the variance was high. Experience will give you a feeling for the type of time you can expect.

    The obvious rule of thumb is: the more data you request, the longer it will take.

    That said, it is more efficient to make one request for many RICs, rather than many requests for few RICs, because of the overhead. See this document for tips on optimizing your requests.

    The maximum number of instruments depends on the type of data you request. See this document for a discussion on several limits, and this page for all the limits per data type.

Answers