Web 服务性能问题

发布于 2024-07-11 18:08:14 字数 343 浏览 5 评论 0原文

我有一个简单的 asmx Web 服务，只需将一些信息记录到事务数据库中。但是对于客户端来说已经超时了。更新数据库的调用仅调用 1 个存储过程，我不相信它可以进一步优化以获得更好的性能。我已经简化为仅使用 log4net 记录运行，然后通过更新数据库的单独进程读取日志。

我想知道是否有更好的方法来做到这一点。我想知道是否有办法让我的代码执行以下操作：

public bool method(...)
{
  LogRun(...)

  Asynchronously call method to insert transaction

  return true;  
}

原文

I've got a simple asmx web service that just needs to log some information to a transactional database. However it is timing out for the client. The call to update the database just calls 1 stored procedure and I don't beleive it could be optimized further for better performance. I've been reduced to just logging the run using log4net and then reading the log in by a separate process that updates the database.

I was wondering if there is a better way to do this. I was wondering if there is a way to make my code do something like:

public bool method(...)
{
  LogRun(...)

  Asynchronously call method to insert transaction

  return true;  
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

酷炫老祖宗 2024-07-18 18:08:14

编辑：我对BackgroundWorker的看法是错误的。于是我把它换成Thread版本，进行测试。

如果你希望异步完成工作，你可以研究如何启动另一个线程。

public class Service1 : System.Web.Services.WebService
{

    [WebMethod]
    public void Log(int foo, int bar)
    {
        Thread a = new Thread(new ThreadStart(delegate()
        {
            // Do some processing here
            // For example, let it sleep for 10 secs
            Thread.Sleep(10000);
        }));
        a.Start();
    }
}

如果 Thread.Sleep(10000) 行位于 Log 方法本身中，则 Log 方法需要 10 秒才能完成处理。然而，对于线程a，Log方法将在调用后立即返回。

另请注意，对于这种异步调用方式，没有简单的方法可以保证调用客户端插入操作是否完成。

EDIT: I was wrong about BackgroundWorker. So I chaged it to the Thread version, tested.

If you want the work done asynchronously, you can study how to start another thread.

public class Service1 : System.Web.Services.WebService
{

    [WebMethod]
    public void Log(int foo, int bar)
    {
        Thread a = new Thread(new ThreadStart(delegate()
        {
            // Do some processing here
            // For example, let it sleep for 10 secs
            Thread.Sleep(10000);
        }));
        a.Start();
    }
}

It would take 10 seconds for Log method to finish processing if the Thread.Sleep(10000) line is in the Log method itself. However, with Thread a, The Log method will return immediately after call.

Also note that, there is no easy way to guarantee the calling client if the insert operation is completed or not, with this style of asynchronous call.

回复收藏 0 原文