Skip to main content
Hi,

When we pull a few months of data over the API, the older the data the slower the pull. We imagine there is some sort of caching on the database. Looks like the threshold is 3 months. If this is true, what can we do to make the pull faster? We usualy dowload 4-6 months worth  of data.

Thanks,

Stelian
3 respostas
  1. 4 de nov. de 2015, 14:00

    Hi Buyan,

    We query Salesforce for 4 months worth of invoice line items.   Currently the request is broken into batches, by month Recently the later months are taking longer.  Since the beginning of October we have been recording the length of time it takes the request to complete and below are some metrics.  

                                  Avg Invoice Line Items    Min Invoice Line Items    Max Invoice Line Item

    Sept. Invoice Line Items        4590.25                922                    8230

    August Invoice Line Items    11152.5                10233                12010

    July Invoice Line Items        12916                12585                13183

    June Invoice Line Items        14676                14535                14809

                                            Avg Time        Min Time        Max Time

    Sept. Invoice Line Items        0:00:10        0:00:03        0:00:14

    August Invoice Line Items    0:00:22        0:00:20        0:00:23

    July Invoice Line Items        0:01:07        0:00:24        0:02:31

    June Invoice Line Items        0:03:28        0:00:18        0:09:05

    On average this year, we request 11k records every request and no more than 16k. 

    These requests are made through SOAP web service calls.