none
how to call 4 million requests to an API endpoint and Save the response for each request to the sql server database in the fastest way?

    Question

  • hi,

    how to call 4 million requests to an API endpoint and Save the response for each request to the SQLl server database in the fastest way? (multithread or asynchronous)

    Monday, April 3, 2017 2:04 PM

All replies

  • hi,

    how to call 4 million requests to an API endpoint and Save the response for each request to the SQLl server database in the fastest way? (multithread or asynchronous)


    You should describe your application with some more detail. Is it one client that is making 4 million calls? Are you pulling data out of the database or  pushing data into the database? Is there some means of cutting the round trips by submitting multiple units of data with one call?
    Monday, April 3, 2017 7:32 PM
  • Is it one client that is making 4 million calls? yes, it is one windows forms application that sends SMS message.

    Are you pulling data out of the database or pushing data into the database? 
    yes, a page (100-300) of messages fetch from the database and try to call API for sending them.

    Is there some means of cutting the round trips by submitting multiple units of data with one call?no there isn't any API to send a list of message.

    Tuesday, April 4, 2017 4:21 AM