ASP.NET Website no Response while Processing Long Process

Posted by Ammar on Stack Overflow See other posts from Stack Overflow or by Ammar
Published on 2010-06-11T18:19:08Z Indexed on 2010/06/11 18:22 UTC
Read the original article Hit count: 311

Filed under:
|
|

Dear Programmers,

When my Application face a long-time process, i.e fetch a query (SELECT a, b, c FROM d) This query needs 10 seconds to be completed in the MSSQL Management Studio, but when the ASP.NET application try to fetch it, it refuse to return any response to any other requests made on that Server.

I am hosting my Application on VPS Server with good specifications, and I am giving this example the (SELECT a, b, c FROM d) just to tell you the issue, it can be any process, maybe processing a movie, or even fetching some data through external API that is experiencing some slow-down,or whatever.

Any help or suggestions would be highly appreciated.

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about slow