❔ Timeout Issue - (SQL Server & CSharp)
Hello guys,
So i have a huge amount of data on my database and i need to make a transaction using procedures with SQL Server and executing those commands through an C# Layer on my backend and sometimes due that high amount of storage data i often get timeout exceptions when doing those actions, i usually put the timeout value as 0 so it's not going to expire my transaction even it takes too long, but recently i tried putting a value like 120s and it solved my timing out issue but i dont get why it worked, is there anyone who can explain to me why it did work and if theres another method to solve these kinda of problems?
Thanks!
So i have a huge amount of data on my database and i need to make a transaction using procedures with SQL Server and executing those commands through an C# Layer on my backend and sometimes due that high amount of storage data i often get timeout exceptions when doing those actions, i usually put the timeout value as 0 so it's not going to expire my transaction even it takes too long, but recently i tried putting a value like 120s and it solved my timing out issue but i dont get why it worked, is there anyone who can explain to me why it did work and if theres another method to solve these kinda of problems?
Thanks!
