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 9 1299
I have change value of item "executiontimeout" in server's
machine.config
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
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 !!!
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 ...
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
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 )
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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();
...
|
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...
|
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...
|
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)....
|
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...
|
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"....
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |