data-api-builder icon indicating copy to clipboard operation
data-api-builder copied to clipboard

Collect profiling information during SWA start-up and first request

Open Mathos1432 opened this issue 3 years ago • 2 comments

At the moment, the SWA-DAB has a cold start of around 30 secs. Collect profiling information to identify the areas where the most time is spent.

We need to wait for PerformOnConfigChangeAsync to complete before returning after the initial call.

We need to investigate improving the performance of this call to reduce latency on the initial request.

Mathos1432 avatar Sep 29 '22 18:09 Mathos1432

@severussundar, after profiling where time is spent the most at startup, we should figure out how we can improve performance of this function PerformOnConfigChangeAsync.

Aniruddh25 avatar Jan 06 '23 02:01 Aniruddh25

Using a huge config file for e.g. the reference config file here used for the integration testing, we see long delay(30s) when initializing SQL for the first time in the hosted solution. So, the performance we improve here should help solve this cold start problem.

Aniruddh25 avatar Feb 21 '23 19:02 Aniruddh25