Click here to Skip to main content
14,984,270 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
If I do some db related operations(insert, update or select), after some operations the IE seems to be busy with server and the page never comes back or the operation will not be committed.

Whats this problem... Please help me...
Posted

Hi,

There could be multiple reasons.

1) Database server may not be having sufficient resources to process the request
2) Database server may be busy in serving other request
3) There could be potential connection leak
4) Connection pool size many not be sufficient
5) There could be locking and blocking issues from the database
6) There could be deadlock issues(contention for the resource)

I hope this helps!.

Regards,
-Vinayak
   
v2
Comments
   
Reason for my vote of 5
Good pointers
thatraja 7-Aug-10 3:26am
   
Reason for my vote of 5
Good answer with plenty of points
You need a faster server, probably.
   
Comments
Raghavendra HG 9-Jul-10 1:37am
   
Its not the problem of that because for the first 4-5 hits it is responding very fast...
I got the answer for this issue.

This was because I was not closing the client object after service method has been called. Now I have called open and close methods of client object like this

objClient.Open();

objClient.CallAMethod();

objClient.Close();
   
v2

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