467,905 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,905 developers. It's quick & easy.

poor performance against Oracle DB on specific machine

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.oracleclient
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?

Feb 25 '07 #1
  • viewed: 1200
Share:
2 Replies
On Feb 25, 4:09 pm, "yoram.aya...@structuredweb.com"
<yoram.aya...@structuredweb.comwrote:
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.oracleclient

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

Feb 25 '07 #2
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**********@structuredweb.com" wrote:
On Feb 25, 4:09 pm, "yoram.aya...@structuredweb.com"
<yoram.aya...@structuredweb.comwrote:
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.oracleclient

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

Feb 26 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Shankar | last post: by
2 posts views Thread by David Gray | last post: by
11 posts views Thread by Dave [Hawk-Systems] | last post: by
13 posts views Thread by bjarne | last post: by
4 posts views Thread by joa2212 | last post: by
12 posts views Thread by Ilyas | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.