.NET中耗时的请求 [英] Time consuming requests in .NET

问题描述

你好，


我有以下问题：


在我的ASPX页面中有一个名为Import的按钮。此按钮的操作是

导入我的数据库中的一组数据。我必须导入大数据集，这个

操作是耗时的（近似3-4小时）。

一小时后我的页面显示错误：


"页面无法显示

您要查找的页面目前无法使用。该网站可能会遇到技术问题，或者您可能需要调整浏览器

设置。

....... ..........

................

无法找到服务器或DNS错误

Internet Explorer"

但在幕后我的导入仍在工作，即使我收到此错误

（我执行的声明如select count（ *）来自myImportedTable"以及

导入的行总数仍然会提高，即使我的浏览器正在显示这个

错误）。


我将以下超时设置修改为hugh值以希望修复此

问题但没有任何结果


1.在我的web.config文件中
< authentication mode =" Forms">

< forms name =" .HRPAUTH" loginUrl = QUOT; login.aspx的" protection =" All"

timeout =" 900">< / forms>

< / authentication>


< sessionState cookieless =" false"超时= QUOT; 1200" mode =" InProc"

stateConnectionString =" tcpip = 127.0.0.1：42424" sqlConnectionString =" data

source = 127.0.0.1; user id = sa; password =" />


2.在我的machine.config文件中

< processModel

enable =" true"

timeout =" Infinite"

idleTimeout =" Infinite"

shutdownTimeout =" 0：00：05"

requestLimit =" Infinite"

requestQueueLimit =" 5000"

restartQueueLimit =" 10"

memoryLimit =" 100"

webGarden =" false"

cpuMask =" 0xffffffff"

userName =" machine"

password =" AutoGenerate"

logLevel =" Errors"

clientConnectedCheck =" 0：00：05"

comAuthenticationLevel ="连接

comImpersonationLevel =" Impersonate"

responseDeadlockInterval =" 10：10：00"

maxWorkerThreads =" 25"

maxIoThreads =" 25"

/>


非常感谢您的帮助！

谢谢

解决方案

我认为你的做法是错误的。而不是试图获得

页面的超时以跟上时间密集型操作，你应该尝试

来让页面初始启动过程然后有一个方法来
检查导入的当前状态。每次你来到页面

后，你会看到使用这个方法调用进行更新。就这样

您还可以看到导入到达了多远，这可能很有用

如果您在导入过程中遇到错误。

Adrian Dragomirescu <广告*********** @ romsystems.com>在消息中写道

news：uG ************** @ TK2MSFTNGP11.phx.gbl ...

你好，
我有以下问题：

在我的ASPX页面中有一个名为Import的按钮。此按钮的操作是
来导入我的数据库中的一组数据。我必须导入大数据集和
这个操作是耗时的（近似3-4小时）。
一小时后我的页面显示错误：

页面不能显示
您要查找的页面目前无法使用。该网站可能会遇到技术问题
，或者您可能需要调整您的
浏览器设置。
................
...............
无法找到服务器或DNS错误
Internet Explorer"

但在幕后我的导入仍然是工作，即使我收到此错误
（我执行声明像从myImportedTable选择计数（*）和
导入的行总数仍然提高，即使我的浏览器正在发出
此错误） 。

我将以下超时设置修改为hugh值以希望解决这个问题但没有任何结果

1.在我的web.config文件中< authentication mode =" Forms">
< forms name =" .HRPAUTH" loginUrl = QUOT; login.aspx的" protection =" All"
timeout =" 900">< / forms>
< / authentication>

< sessionState cookieless =" false"超时= QUOT; 1200" mode =" InProc"
stateConnectionString =" tcpip = 127.0.0.1：42424" sqlConnectionString =" data
source = 127.0.0.1; user id = sa; password =" />

2.在我的machine.config文件中
< processModel
enable =" true"
timeout =" Infinite"
idleTimeout =" Infinite"
shutdownTimeout =" 0:00:05"
requestLimit =" Infinite"
requestQueueLimit =" 5000"
restartQueueLimit =" 10"
memoryLimit =" 100"
webGarden =" false"
cpuMask =" 0xffffffff"
userName =" machine"
password =" AutoGenerate"
logLevel =" Errors"
clientConnectedCheck =" 0：00：05"
comAuthenticationLevel =" Connect"
comImpersonationLevel =" Impersonate"
responseDeadlockInterval = 10：10：00
maxWorkerThreads =&qu ot; 25"
maxIoThreads =" 25"
/>

感谢你的帮助！
谢谢

Thanx为您的回复Janaka。我怎样才能实现这种行为，开始导入的过程和同时接收我的页面的回发

（来自服务器的响应）？你能帮帮我吗？


" Janaka" < JA **** @ magicalia.com>在消息中写道

新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl ...

我认为你以错误的方式去做这件事。而不是试图获得
页面的超时以跟上时间密集型操作，你应该尝试
让页面初始启动过程，然后有一个方法来
检查导入的当前状态。每次进入页面后，您都会看到使用此方法调用的进度更新。那个
的方式你也可以看到导入到底有多远，这也很有用
如果你在导入过程中遇到错误。

" Adrian Dragomirescu" <广告*********** @ romsystems.com>在消息中写道
新闻：uG ************** @ TK2MSFTNGP11.phx.gbl ...

你好，
我有以下问题：

在我的ASPX页面中有一个名为Import的按钮。此按钮
的操作是

到

导入我的数据库中的一组数据。我必须导入大数据集，这个

操作是耗时的（近似3-4小时）。
一小时后我的页面显示错误：

" ;页面无法显示
您要查找的页面目前无法使用。网站

可能是

遇到技术问题，或者您可能需要调整

浏览器< blockquote class =post_quotes>设置。
................
............... />无法找到服务器或DNS错误
Internet Explorer

但在幕后我的导入仍在工作，即使我收到了这个

错误（我执行的语句类似于从myImportedTable中选择计数（*）和
即使我的浏览器正在调度，导入行的总数仍会提高

此

错误）。

我将以下超时设置修改为hugh值，希望解决这个问题，但没有任何结果

1.在我的网站上.config文件
< authentication mode =" Forms">
< forms name =" .HRPAUTH" loginUrl = QUOT; login.aspx的" protection =" All"
timeout =" 900">< / forms>
< / authentication>

< sessionState cookieless =" false"超时= QUOT; 1200" mode =" InProc"
stateConnectionString =" tcpip = 127.0.0.1：42424" sqlConnectionString =" data
source = 127.0.0.1; user id = sa; password =" />

2.在我的machine.config文件中
< processModel
enable =" true"
timeout =" Infinite"
idleTimeout =" Infinite"
shutdownTimeout =" 0:00:05"
requestLimit =" Infinite"
requestQueueLimit =" 5000"
restartQueueLimit =" 10"
memoryLimit =" 100"
webGarden =" false"
cpuMask =" 0xffffffff"
userName =" machine"
password =" AutoGenerate"
logLevel =" Errors"
clientConnectedCheck =" 0：00：05"
comAuthenticationLevel =" Connect"
comImpersonationLevel =" Impersonate"
responseDeadlockInterval = 10：10：00
maxWorkerThreads =&qu ot; 25"
maxIoThreads =" 25"
/>

感谢你的帮助！
谢谢

这取决于你的实际应用程序将要做什么。你能用

来描述目前的进口流程吗。

" Adrian Dragomirescu" <广告*********** @ romsystems.com>在消息中写道

新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl ...

Thanx for你的回应Janaka。我怎样才能实现这种行为，以
启动导入过程并同时接收我的页面的回发
（来自服务器的响应）？你能帮助我吗？

Janaka < JA **** @ magicalia.com>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl ...

我想你的意见错误的方法。而不是试图获得

page'超时以跟上时间密集型操作，你应该试试
页面，以初始启动该过程，然后有一个方法来检查导入的当前状态。每次进入页面后，您都会看到使用此方法调用的进度更新。那个

方式

你还可以看到导入到达了多远，这也很有用
如果你在导入中途遇到错误。

" Adrian Dragomirescu" <广告*********** @ romsystems.com>在消息中写道
新闻：uG ************** @ TK2MSFTNGP11.phx.gbl ...

你好，
我有以下问题：

在我的ASPX页面中有一个名为Import的按钮。此按钮的操作

是

到

导入我的数据库中的一组数据。我必须导入大数据集和

这个

操作是耗时的（近似3-4小时）。
一小时后我的页面显示错误：

页面无法显示
您要查找的页面目前无法使用。网站

可能

遇到技术问题，或者您可能需要调整

设置。
................
............. ..
无法找到服务器或DNS错误
Internet Explorer

但是在幕后我的导入仍在工作，即使我收到了这个

错误（我执行的语句类似于从myImportedTable中选择计数（*）并且导入的行总数仍然会提高，即使我的浏览器正在调度

此

错误）。

我将以下超时设置修改为hugh值以希望修复
此问题但没有任何结果

1.在我的web.config文件中< br&>< authentication mode =" Forms">
< forms name =" .HRPAUTH" loginUrl = QUOT; login.aspx的" protection =" All"
timeout =" 900">< / forms>
< / authentication>

< sessionState cookieless =" false"超时= QUOT; 1200" mode =" InProc"
stateConnectionString =" tcpip = 127.0.0.1：42424"
sqlConnectionString =" data source = 127.0.0.1; user id = sa; password =" />

2.在我的machine.config文件中
< processModel
enable =" true"
timeout =" Infinite"
idleTimeout =" Infinite"
shutdownTimeout =" 0:00:05"
requestLimit =" Infinite"
requestQueueLimit =" 5000"
restartQueueLimit =" 10"
memoryLimit =" 100"
webGarden =" false"
cpuMask =" 0xffffffff"
userName =" machine"
password =" AutoGenerate"
logLevel =" Errors"
clientConnectedCheck =" 0：00：05"
comAuthenticationLevel =" Connect"
comImpersonationLevel =" Impersonate"
responseDeadlockInterval = 10：10：00
maxWorkerThreads =&qu ot; 25"
maxIoThreads =" 25"
/>

感谢你的帮助！
谢谢

Hello,

I have the following problem:

In my ASPX page is a button called "Import". The action of this button is to
import a set of data in my database. I have to import big datasets and this
opperation is time consuming (aproximativelly 3-4 hours).
After an hour my page display the error:

"The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be
experiencing technical difficulties, or you may need to adjust your browser
settings.
.................
................
Cannot find server or DNS Error
Internet Explorer "
But behind the scene my import is still working even i received this error
(i executed statement like "select count(*) from myImportedTable" and the
total number of imported rows still raise even my browser is dispaying this
error).

I modified the following timeout setting to hugh values to hope fix this
problem but without any result

1. in my web.config file
<authentication mode="Forms">
<forms name=".HRPAUTH" loginUrl="login.aspx" protection="All"
timeout="900"></forms>
</authentication>

<sessionState cookieless="false" timeout="1200" mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data
source=127.0.0.1;user id=sa;password=" />

2. in my machine.config file
<processModel
enable="true"
timeout="Infinite"
idleTimeout="Infinite"
shutdownTimeout="0:00:05"
requestLimit="Infinite"
requestQueueLimit="5000"
restartQueueLimit="10"
memoryLimit="100"
webGarden="false"
cpuMask="0xffffffff"
userName="machine"
password="AutoGenerate"
logLevel="Errors"
clientConnectedCheck="0:00:05"
comAuthenticationLevel="Connect"
comImpersonationLevel="Impersonate"
responseDeadlockInterval="10:10:00"
maxWorkerThreads="25"
maxIoThreads="25"
/>

Your help is appreciated!
Thanks

解决方案

I think your going about this the wrong way. Instead of trying to get the
page''s timeout to keep up with the time-intensive operation you should try
to get the page to initially start the process and then have a method to
check the current status of your import. Each time you come to the page
afterwards you will see a progress update using this method call. That way
you could also see how far the import has gotten to, which can be useful
also if you run into errors halfway through an import.
"Adrian Dragomirescu" <ad***********@romsystems.com> wrote in message
news:uG**************@TK2MSFTNGP11.phx.gbl...

Hello,

I have the following problem:

In my ASPX page is a button called "Import". The action of this button is to import a set of data in my database. I have to import big datasets and this opperation is time consuming (aproximativelly 3-4 hours).
After an hour my page display the error:

"The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.
................
...............
Cannot find server or DNS Error
Internet Explorer "
But behind the scene my import is still working even i received this error
(i executed statement like "select count(*) from myImportedTable" and the
total number of imported rows still raise even my browser is dispaying this error).

I modified the following timeout setting to hugh values to hope fix this
problem but without any result

1. in my web.config file
<authentication mode="Forms">
<forms name=".HRPAUTH" loginUrl="login.aspx" protection="All"
timeout="900"></forms>
</authentication>

<sessionState cookieless="false" timeout="1200" mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data
source=127.0.0.1;user id=sa;password=" />

2. in my machine.config file
<processModel
enable="true"
timeout="Infinite"
idleTimeout="Infinite"
shutdownTimeout="0:00:05"
requestLimit="Infinite"
requestQueueLimit="5000"
restartQueueLimit="10"
memoryLimit="100"
webGarden="false"
cpuMask="0xffffffff"
userName="machine"
password="AutoGenerate"
logLevel="Errors"
clientConnectedCheck="0:00:05"
comAuthenticationLevel="Connect"
comImpersonationLevel="Impersonate"
responseDeadlockInterval="10:10:00"
maxWorkerThreads="25"
maxIoThreads="25"
/>

Your help is appreciated!
Thanks

Thanx for your response Janaka. How can i implement this behavior, to start
the process of import and the same time to receive the postback of my page
(the response from the server)? Can you help me?

"Janaka" <ja****@magicalia.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I think your going about this the wrong way. Instead of trying to get the
page''s timeout to keep up with the time-intensive operation you should try
to get the page to initially start the process and then have a method to
check the current status of your import. Each time you come to the page
afterwards you will see a progress update using this method call. That way you could also see how far the import has gotten to, which can be useful
also if you run into errors halfway through an import.
"Adrian Dragomirescu" <ad***********@romsystems.com> wrote in message
news:uG**************@TK2MSFTNGP11.phx.gbl...

Hello,

I have the following problem:

In my ASPX page is a button called "Import". The action of this button is

to

import a set of data in my database. I have to import big datasets and this

opperation is time consuming (aproximativelly 3-4 hours).
After an hour my page display the error:

"The page cannot be displayed
The page you are looking for is currently unavailable. The Web site

might be

experiencing technical difficulties, or you may need to adjust your

browser

settings.
................
...............
Cannot find server or DNS Error
Internet Explorer "
But behind the scene my import is still working even i received this

error (i executed statement like "select count(*) from myImportedTable" and the total number of imported rows still raise even my browser is dispaying

this

error).

I modified the following timeout setting to hugh values to hope fix this
problem but without any result

1. in my web.config file
<authentication mode="Forms">
<forms name=".HRPAUTH" loginUrl="login.aspx" protection="All"
timeout="900"></forms>
</authentication>

<sessionState cookieless="false" timeout="1200" mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data
source=127.0.0.1;user id=sa;password=" />

2. in my machine.config file
<processModel
enable="true"
timeout="Infinite"
idleTimeout="Infinite"
shutdownTimeout="0:00:05"
requestLimit="Infinite"
requestQueueLimit="5000"
restartQueueLimit="10"
memoryLimit="100"
webGarden="false"
cpuMask="0xffffffff"
userName="machine"
password="AutoGenerate"
logLevel="Errors"
clientConnectedCheck="0:00:05"
comAuthenticationLevel="Connect"
comImpersonationLevel="Impersonate"
responseDeadlockInterval="10:10:00"
maxWorkerThreads="25"
maxIoThreads="25"
/>

Your help is appreciated!
Thanks

Well it depends on what your actual application is going to do. Can you
describe the import process that is currently in place.
"Adrian Dragomirescu" <ad***********@romsystems.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Thanx for your response Janaka. How can i implement this behavior, to start the process of import and the same time to receive the postback of my page
(the response from the server)? Can you help me?

"Janaka" <ja****@magicalia.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I think your going about this the wrong way. Instead of trying to get the

page''s timeout to keep up with the time-intensive operation you should try to get the page to initially start the process and then have a method to
check the current status of your import. Each time you come to the page
afterwards you will see a progress update using this method call. That

way

you could also see how far the import has gotten to, which can be useful
also if you run into errors halfway through an import.
"Adrian Dragomirescu" <ad***********@romsystems.com> wrote in message
news:uG**************@TK2MSFTNGP11.phx.gbl...

Hello,

I have the following problem:

In my ASPX page is a button called "Import". The action of this button

is

to

import a set of data in my database. I have to import big datasets and

this

opperation is time consuming (aproximativelly 3-4 hours).
After an hour my page display the error:

"The page cannot be displayed
The page you are looking for is currently unavailable. The Web site

might

be

experiencing technical difficulties, or you may need to adjust your

browser

settings.
................
...............
Cannot find server or DNS Error
Internet Explorer "
But behind the scene my import is still working even i received this

error (i executed statement like "select count(*) from myImportedTable" and the total number of imported rows still raise even my browser is dispaying

this

error).

I modified the following timeout setting to hugh values to hope fix this problem but without any result

1. in my web.config file
<authentication mode="Forms">
<forms name=".HRPAUTH" loginUrl="login.aspx" protection="All"
timeout="900"></forms>
</authentication>

<sessionState cookieless="false" timeout="1200" mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=" />

2. in my machine.config file
<processModel
enable="true"
timeout="Infinite"
idleTimeout="Infinite"
shutdownTimeout="0:00:05"
requestLimit="Infinite"
requestQueueLimit="5000"
restartQueueLimit="10"
memoryLimit="100"
webGarden="false"
cpuMask="0xffffffff"
userName="machine"
password="AutoGenerate"
logLevel="Errors"
clientConnectedCheck="0:00:05"
comAuthenticationLevel="Connect"
comImpersonationLevel="Impersonate"
responseDeadlockInterval="10:10:00"
maxWorkerThreads="25"
maxIoThreads="25"
/>

Your help is appreciated!
Thanks

这篇关于.NET中耗时的请求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！