0

I have a bot built using botbuilder Sdk V3 that needs to make azure sql Db calls upon user's questions. We have about 10k users who might be accessing this bot in production making concurrent requests (not all 10k but few ) few times per day.

I am thinking to have some Retry logic in my code, connection pooling, connection timeouts that will help to manage database connections gracefully.

I have tried sample here which doesn't do any retry or pooling.

I have searched all examples here but didn't find nodejs example doing what I need.

I am expecting to do something like this mentioned in the document.

vijay
  • 109
  • 11

1 Answers1

1

I suggest looking into tedious and tedious connection pool. I've used them for Azure SQL in production for over 3 years and it's worked great (without special retry logic).

MattB
  • 1,104
  • 8
  • 15