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 1300
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 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...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |