SQL FileStream - Concurrency support

• bakugo

  Grasshopper

  Points: 12

  More actions

  July 29, 2022 at 7:26 pm

  #4070115

  Hi team,

  We have already enabled a SQL filestream for storing API request and response contents in one of our audit table. It works fine in PROD.

  Now we want to add more traffic to it, earlier, the traffic comes from 1 API, now we want to enable Audit for other APIs with request content with more transactions which means request message will be quite large compared to previous ones..

  Now the question we have ?. Will SQL filestream support concurrency (multiple concurrent request). Will there be any impact in terms of performance leading to Timeout for API ?.. Will there be any impact in nightly back up ?

  Right now, we have single insert procedure to insert the records into that table.. if we feel, it will be a problem for concurrent request, then we can think of splitting the table into multiple for each API and have separate insert stored procedure ?

  Also provide some view on Filestream vs Blob in terms of size

  Thanks

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 30, 2022 at 8:10 pm

  #4070439

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• August 31, 2022 at 9:13 am

  This was removed by the editor as SPAM