473,287 Members | 1,582 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

ASP NET server can not response after long job

Hi everyone:
I have a problem in ASP NET. Here is my situation.
I developed an ASP NET application. It concerns data statistics.
DB is oracle 10g, Web server is IIS 6.0, Server OS is Win2003, Client
OS is Winxp,
Develepment Platform is VS2003. In DB, data of a major table is huge,
( 6~9 milllions)
I have to do some statistics on that huge table, then fill the result
to htmltable.
Here comes the problem.
If the job takes less than 5~6 minutes, IE of client will show the
correct result.
If the job takes more than 6 minutes, IE of client has no response.
When I monitored
the log in Server, it showed the job had completed. So I doubt server
can not push the
data back to client after the request takes more than 5~6 minutes.
could some one give me some advices?
any suggestion will be appreciated.

Server Hardware : DELL SERVER P4 3.0G, 1G RAM, 160G HD
IIS and Oracle 10g are installed in the same machine.
Does two of them conflict in one server?
Sorry for my poor english

May 19 '06 #1
9 1299
I have change value of item "executiontimeout" in server's
machine.config

May 19 '06 #2
You should consider using asynchronous execution of this task in a non
aspnet worker thread.

Because right now you are using an ASPNET worker thread to perform your
logic. If you have any questions about asynchronous execution post a
question.

Regards,
Tasos

May 19 '06 #3
firstly thanks a lot.
And can asynchronous execution shorten the time to 5~6 minutes?
you know, the major table can be more and more huge,
even you use multithread to process the job, it will still take you
more than 5~6 minutes when data reaches such a proper count.
I admit there are some faults in database design. But it has legacy
data, I can do nothing on it.

is there some else trick? or I have not get your point clear?
please !!!

May 19 '06 #4
I don't know if asynchronous execution will shorten the time, but you
will free an aspnet worker thread that can be used to serve other
requests (having nothing to do with the db logic).

By using an asynchronous request you utilize in a more efficient way
the worker threads of your application and you can show a "Please wait"
to the user and probably a status bar or sth ...

May 19 '06 #5
To solve this problem, I cloned a deploy environment.
And even one request one time, no other jobs were due to process,
I waited for a long time, the problem still occured.

BTW: I did some extra test. just hard coding some delay in process user

request("thread.sleep(n)" such stuff), it still does not work.
what a weird problem

May 19 '06 #6
Hi Jacob,
Please reconsider your schema design..
If you have a primary key in a table You can create a clustered index
on it.
If you have a foriegn keys please create a database diagram to give the
realationships among them so that the query runs very fast. Optimize
your database with indexes.
and see the difference.
--
Muthu Kumaran.D
(unknown is ocean )

May 19 '06 #7
Hi mkumaran
3ks. I got ur point.
But it is a legacy database with legacy data.
I had an idea about redesigning the database before.
I can not guarantee the impact of redesign
maybe legacy system will crush.
so it is pity that i can not take your advice.
thanks a lot

May 19 '06 #8
Hi Jacob,
Do one thing,
Take Full back up of your database and restore it somewhere else. And
try those things I have told to you. It wil definitely help you to sort
out of this problem. If this idea not worked for you You can carry on
with your legacy old database.
Bye,
Muthu Kumaran.D

May 19 '06 #9
five minutes is too long. you need to start a back ground thread to do the
work, then have the browser poll for completion. google this group on
progress bar for more info.

-- bruce (sqlwork.com)

"jacob" <dU*******@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
Hi everyone:
I have a problem in ASP NET. Here is my situation.
I developed an ASP NET application. It concerns data statistics.
DB is oracle 10g, Web server is IIS 6.0, Server OS is Win2003, Client
OS is Winxp,
Develepment Platform is VS2003. In DB, data of a major table is huge,
( 6~9 milllions)
I have to do some statistics on that huge table, then fill the result
to htmltable.
Here comes the problem.
If the job takes less than 5~6 minutes, IE of client will show the
correct result.
If the job takes more than 6 minutes, IE of client has no response.
When I monitored
the log in Server, it showed the job had completed. So I doubt server
can not push the
data back to client after the request takes more than 5~6 minutes.
could some one give me some advices?
any suggestion will be appreciated.

Server Hardware : DELL SERVER P4 3.0G, 1G RAM, 160G HD
IIS and Oracle 10g are installed in the same machine.
Does two of them conflict in one server?
Sorry for my poor english

May 19 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: kevin | last post by:
Hi, Any help with this would be really appreciated! I'm trying to download a file from a remote server. The access permissions is okay but the problem I'm facing is that the file is getting...
3
by: Teckie03 | last post by:
Hi, does anyone know how to display a seperate browser from server process? My ASP.NET app control (ascx) has Archive button that does its own work , including updating an html page called...
1
by: Ryan McLean | last post by:
Hi everyone! What is happening is the method: sub_btnSubmitClicked is being executed every time any other object with a Handler is executed. I am trying not to use the withevents and handles...
1
by: Alstersjo | last post by:
Hi I am trying to develop an web application that should use netsh dhcp to show information about our dhcp scope. The problem is that our dhcp server is different from our IIS (iis6). I am trying...
1
by: Kevin | last post by:
I'm using a MagTek check / credit card scanner to scan checks and then submit the check data to NovaInfo through their viaWarp Gateway. The NovaInfo people won't even return my emails, so I'm...
7
by: skeddy | last post by:
In a nutshell, I'm trying to dynamically create a select box with ResultSet code in vbscript and then need to be able to access the value of that select box later with a Save button. I've got...
5
by: pbd22 | last post by:
Hi. I am trying to poll a long-running process via a hidden IFrame. I am noticing that the online errata gives advice for handling a server response: window.parent.handleServerResponse(); ...
0
by: Lasse Edsvik | last post by:
Hello I have a strange problem, I'm using Debitech for a system that handles payments. And I have this Response.Redirect(https://long address) that is sent to their server with a long...
4
by: TS | last post by:
Steven, i lost this message conversation from outlook express and made a post online (see last one on this page). Please answer it as it hasn't been yet. thanks The clientID of our controls...
9
by: RN1 | last post by:
When a server encounters the line Response.Redirect("abcd.asp") in a ASP script, the server tells the browser that it has to be redirected to another page (which is abcd.asp, in this case)....
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.