Click here to Skip to main content
15,065,044 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...

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




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!.

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.
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...

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