ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,208 questions
Calling Web Api's with multiple databases at regular intervals using a scheduler in C#
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 26%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
abhishek singh rana
1
Reputation point
0
I am working on Dot Net 5 application where I have multiple web api's with different databases. So when I make 1st request to any of the API, the response time is huge(6-7 sec, because the connection object is getting created & connection being established) but the subsequent requests are fast as the connection object already exist.
Now, to overcome this scenario I am trying to implement a scheduler which will ping all the web api's with some dummy request at regular interval say 3 seconds so that the response time is reduced. I am using ADOMD.net for the connection with the databases.
I tried searching a lot over the google but I couldn't find any proper sources to depict the above mentioned problem. Can you all please provide me some insights and the steps to proceed with this problem?? Some examples would also be appreciated.
Thanks in advance :).
ASP.NET Core
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,308 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 78%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
Brando Zhang-MSFT 2,961 Reputation points Microsoft Vendor2021-09-18T01:48:43.177+00:00 @abhishek singh rana Could you please tell me where you hosted your web api application on the IIS or windows service or else? Could you please tell me which database you have used in your application? I think we need to figure our which part caused the first request latency. The server need to start the application and this part takes some long time and the application connect to the database takes so long time.
Sign in to comment