Do you mean have more clients calling this stored procedure? . Yes .. Will there be any concurrent issue if we try to perform concurrent inserts in File Stream enabled...

• This reply was modified 2 years, 6 months ago by  Mia2022.

ok.. The API I referred is ASP.Net API (Middleware) not FS API...  We already using T-SQL to store the request & response in FS enabled columns using insert stored procedures......

Thanks.

Yes we are inserting records in batches not bulk insert.

What i understood so far is, we need to focus more on normal table rather on focusing on filestream enabled tables...

• This reply was modified 3 years, 5 months ago by  Mia2022.

Ok. To make it clear, if i insert around 5 million records in one stretch for load testing, will it be a problem however it might not be the case...

• This reply was modified 3 years, 5 months ago by  Mia2022. Reason: Added details