Click here to Skip to main content
15,878,003 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a C# program that has 30 threads running simoltaneously. Each of these threads are connected to the same data base whith seperated sql Connections when I call functions or stored procedures to receive data from the DB I didn't receive anything in 6% of cases (the connection is open) I should mention that the stored procedures is working correctly because I have stored the result of the SP in a table in DB. This problem starts since I Add a table to DB that each record of that has 8 kb Data and the process of each thread got longer however load of data and error is at the beginning of process.Is there any suggestion about this problem.(c# .net 2.5 sql server 2008)
Posted
Updated 25-Mar-11 23:44pm
v2

1 solution

If I understood the description correctly, this could be a timeout issue if the execution of a procedure takes a long time. Do you get any error messages and do you have proper error handling in the threads.

Also if you're modifying the data in some of the threads it could also be a concurrency issue, another thread modifies the data but hasn't committed it yet while another reads the data.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900