we are deploying a ASP.NET 2.0 web application (written in vb.net) to
a windows Server 2003 web edition in which .NET framework 2.0 has been
instaled. the application connects to an Oracle 9i database, and uses
system.date.ora cleclient
our development machine windows runs XP, has VS 2005 installed.
our local testing machine runs windows 2003 enterprise edition, has VS
2005 installed.
on these 2 machines we get good performance, even though the testing
DB server resides on a remote network
however, on the target machine, which resides on same local network
where the same testing DB server is located, we get poor performance,
especially on pages that access the DB extensively.
any ideas?
2  1374 
On Feb 25, 4:09 pm, "yoram.aya...@s tructuredweb.co m"
<yoram.aya...@s tructuredweb.co mwrote:
we are deploying a ASP.NET 2.0 web application (written in vb.net) to
a windows Server 2003 web edition in which .NET framework 2.0 has been
instaled. the application connects to an Oracle 9i database, and uses
system.date.ora cleclient
our development machine windows runs XP, has VS 2005 installed.
our local testing machine runs windows 2003 enterprise edition, has VS
2005 installed.
on these 2 machines we get good performance, even though the testing
DB server resides on a remote network
however, on the target machine, which resides on same local network
where the same testing DB server is located, we get poor performance,
especially on pages that access the DB extensively.
any ideas?
oops, I found it. for some reasons we cannot send email to local SMTP
server, and all calls to sendmail (for debugging purposes) were
slowing down execution
Yep. Of course, you had a try / catch block around that SMTP call and wrote
the exception into your exception log and that's how you found it, right? :-)
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net
"yo**********@s tructuredweb.co m" wrote:
On Feb 25, 4:09 pm, "yoram.aya...@s tructuredweb.co m"
<yoram.aya...@s tructuredweb.co mwrote:
we are deploying a ASP.NET 2.0 web application (written in vb.net) to
a windows Server 2003 web edition in which .NET framework 2.0 has been
instaled. the application connects to an Oracle 9i database, and uses
system.date.ora cleclient
our development machine windows runs XP, has VS 2005 installed.
our local testing machine runs windows 2003 enterprise edition, has VS
2005 installed.
on these 2 machines we get good performance, even though the testing
DB server resides on a remote network
however, on the target machine, which resides on same local network
where the same testing DB server is located, we get poor performance,
especially on pages that access the DB extensively.
any ideas?
oops, I found it. for some reasons we cannot send email to local SMTP
server, and all calls to sendmail (for debugging purposes) were
slowing down execution
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Shankar |
last post by:
Hello,
I am seeing huge performance problems on the queries executed against
9i database. I am not too familiar with 9i, But I would like to ask
the DBA to check whether all the parameters are set right to gain
optimum performance.
Currently the default optimizer is set to first_rows.
Most of the queries executed against this database have group by
clause
|
by: Ruth |
last post by:
Hi All
I am not a DBA, but a unix administrator.
After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our
test server, we have noticed a big slow down in our application
(acocobol). From ~10mins to ~45mins.
Server info:
|
by: David Gray |
last post by:
Hello Gurus,
SQL Server 2000
Windows 2003 Server, Standard Edition.
Firstly I'm not a SQL server DBA but have a little experience with
Oracle 9i and Oracle Rdb.
An application that I've inherited has started performing very very
slowly over the last few days, as far as I know there have been no
|
by: Dave [Hawk-Systems] |
last post by:
have the table "numbercheck"
Attribute | Type | Modifier
-----------+------------+----------
svcnumber | integer | not null
svcqual | varchar(9) |
svcequip | char(1) |
svctroub | varchar(6) |
svcrate | varchar(4) |
svcclass | char(1) |
trailer | varchar(3) |
|
by: bhbgroup |
last post by:
I have a query on one large table. I only add one condition, i.e. a
date (the SQL reads like 'where date > parameterdate'.
This query is rather quick if 'parameterdate' is either explicitly
written into the query or if it is a 'normal' access parameter value
that is entered during the query.
If I however create a separate parameter table that contains nothing
but the date I want to use in the query and then refer to this table
(the query...
| | |
by: bjarne |
last post by:
Willy Denoyette wrote;
> ... it
> was not the intention of StrousTrup to the achieve the level of efficiency
> of C when he invented C++, ...
Ahmmm. It was my aim to match the performance of C and I achieved that
aim very early on. See, for example "The Design and Evolution of C++".
-- Bjarne Stroustrup; http://www.research.att.com/~bs
|
by: joa2212 |
last post by:
Hello everybody,
I'm posting this message because I'm quiet frustrated.
We just bought a software from a small software vendor. In the
beginning he hosted our application on a small server at his office. I
think it was a Fujitsu-Siemens x86 running debian Linux. The
performance of the DSL-Line was very poor, so we decided to buy an own
machine to host the application ourselves.
|
by: Manish |
last post by:
I think this question has been asked number of times. However, I am
looking for some specific information. Perhaps some of you can help
close the gap. Or perhaps you can point me towards right direction.
Perhaps this group can help me fill in ms-sqlserver related following
questions.
1. Do this database have data Clustering capabilities?
1a. If yes, what mechanism is used such as shared disk, share nothing,
etc.
|
by: Ilyas |
last post by:
Hi all
I have an application which brings back 1000 records from a sql server
database. Under the local asp.net development server provided with
Visual Studio 2008, it takes about 1.8 seconds
When I place this application in IIS it takes 16 seconds for the exact
bit of code. I have narrowed the code down to loopoing around the
dataset and creating an object for every row in the dataset. My
question is why does it take so long under...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
