snowflake-connector-net icon indicating copy to clipboard operation
snowflake-connector-net copied to clipboard

SNOW-165479: Blocking thread on retry handler

Open pcchannz opened this issue 4 years ago • 0 comments

https://github.com/snowflakedb/snowflake-connector-net/blob/3adccf292e8e582a9c56cbbfb039fba7a826807c/Snowflake.Data/Core/HttpUtil.cs#L207

Replace with asynchronous wait: await Task.Delay(backOffInSec * 1000);

I observed that during heavy load, the waiting time on retry handler could add up.

Prior updating the line, 35% of my application threads were spent on synchronous sleep. image

After updating the line, it was around 8.5% image

Thank you!

pcchannz avatar Jun 08 '20 02:06 pcchannz