Time out happens after every 4-5 hits to DB

Question

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 8-Jul-10 19:06pm

Raghavendra HG

Add a Solution

3 solutions

Solution 1

You need a faster server, probably.

Posted 8-Jul-10 19:27pm

Christian Graus

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

Solution 3

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();

Posted 24-Nov-10 23:34pm

Raghavendra HG

Updated 24-Nov-10 23:36pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Vinayaka Krishna Shenoy · Accepted Answer · 2010-08-05T23:05:00

Solution 2

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

Posted 5-Aug-10 23:05pm

Vinayaka Krishna Shenoy

Updated 6-Aug-10 21:27pm

v2

Comments

vinayakshenoy2000@gmail.com 6-Aug-10 5:22am

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