每4-5次击中数据库就会发生超时 [英] Time out happens after every 4-5 hits to DB

问题描述

如果我执行了一些与数据库相关的操作(插入，更新或选择)，则在执行某些操作后，IE似乎正忙于服务器，并且页面再也不会返回，或者将不会提交该操作.

这是什么问题...请帮助我...

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

推荐答案

可能有多种原因.
1)数据库服务器可能没有足够的资源来处理请求
2)数据库服务器可能正在忙于处理其他请求
3)可能存在连接泄漏
4)连接池大小很多不足
5)数据库可能存在锁定和阻止问题
6)可能存在死锁问题(争用资源)

希望对您有所帮助！.

问候，
-Vinayak

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

您可能需要更快的服务器.

You need a faster server, probably.

我已经找到了解决此问题的方法.

这是因为在调用service方法之后，我没有关闭 client对象.现在，我已经这样调用了客户端对象的 open 和 close 方法

objClient.Open();

objClient.CallAMethod();

objClient.Close();

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

这篇关于每4-5次击中数据库就会发生超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！