473,387 Members | 1,534 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,387 software developers and data experts.

CDOSYS executes but takes TOO TOO long?

Hey all...
running w2k3/iis6 and trying to shorten the length of time that a simple 10
field ASP form takes to execute using CDOSYS. it takes about 50 seconds each
time...and I've no idea why?

any pointers here lads? on other servers the exact same script does it's job
in 3 seconds...but not this one?

???

Jim
Feb 20 '08 #1
14 2062
so, the ASP code is working but it takes too long on a given server......

have you contacted the server administrator ??

checked any logs ??

or ????

how are we supposed to help with this ?
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message news:F5**********************************@microsof t.com...
Hey all...
running w2k3/iis6 and trying to shorten the length of time that a simple 10
field ASP form takes to execute using CDOSYS. it takes about 50 seconds each
time...and I've no idea why?

any pointers here lads? on other servers the exact same script does it's job
in 3 seconds...but not this one?

???

Jim

Feb 20 '08 #2
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:F5**********************************@microsof t.com...
Hey all...
running w2k3/iis6 and trying to shorten the length of time that a simple
10
field ASP form takes to execute using CDOSYS. it takes about 50 seconds
each
time...and I've no idea why?

any pointers here lads? on other servers the exact same script does it's
job
in 3 seconds...but not this one?
It might be worth you confirming which part of your script is taking most of
the time but its going to be the send. It will be some configuration
problem that is causing something like DNS lookups or user authentication to
take a long time.
--
Anthony Jones - MVP ASP/ASP.NET
Feb 20 '08 #3
First thanks guys. Next, its on my own ded server so that makes me the
SysAdmin I suppose. Next, I do not know any manner to test "which" part of
the script is taking the time. Mailogs show it's in the outbound queue for
seconds, so I doubt that the problem is with MainEnablePro. It must be IMHO,
the script itself, yet as I said it runs in 3 secs on other servers. Hmmm,
maybe it's the library I'm using as it's still the w2k one... ie

METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"

Anyone know, is there a more recent one for w2k3? Might that be "it" problem
wise?

Jim

Feb 21 '08 #4
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:CE**********************************@microsof t.com...
First thanks guys. Next, its on my own ded server so that makes me the
SysAdmin I suppose. Next, I do not know any manner to test "which" part of
the script is taking the time.
Here is a noddy example.

Dim sPath
Dim oStream

sPath = Server.MapPath("/myLogs/" & Session.SessionID & ".log")
Dim fso : Set fso = CreateObject("Scripting.FileSystemObject")
Dim oStream: Set oStream = fso.OpenTextFile(sPath, 8, True)

oStream.WriteLine "Script Started: " & Now

'Code building message in oMsg

oStream.WriteLine "Entering Send: " & Now

oMsg.Send

oStream.WriteLine "Exited Send:" & Now

oStream.Close

>Mailogs show it's in the outbound queue for
seconds, so I doubt that the problem is with MainEnablePro. It must be
IMHO,
the script itself, yet as I said it runs in 3 secs on other servers. Hmmm,
maybe it's the library I'm using as it's still the w2k one... ie

METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"

Anyone know, is there a more recent one for w2k3? Might that be "it"
problem
wise?
I doubt it. The GUID is the same on XP and 2003. Its the same component.

--
Anthony Jones - MVP ASP/ASP.NET
Feb 22 '08 #5
Do you mean, Anthony, that I should just cut and paste that script into a new
..asp page, run it on the server in the domain root folder and then see what
happens?

ie is that how I'd get a report on same?

Jim

"Anthony Jones" wrote:
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:CE**********************************@microsof t.com...
First thanks guys. Next, its on my own ded server so that makes me the
SysAdmin I suppose. Next, I do not know any manner to test "which" part of
the script is taking the time.

Here is a noddy example.

Dim sPath
Dim oStream

sPath = Server.MapPath("/myLogs/" & Session.SessionID & ".log")
Dim fso : Set fso = CreateObject("Scripting.FileSystemObject")
Dim oStream: Set oStream = fso.OpenTextFile(sPath, 8, True)

oStream.WriteLine "Script Started: " & Now

'Code building message in oMsg

oStream.WriteLine "Entering Send: " & Now

oMsg.Send

oStream.WriteLine "Exited Send:" & Now

oStream.Close

Mailogs show it's in the outbound queue for
seconds, so I doubt that the problem is with MainEnablePro. It must be
IMHO,
the script itself, yet as I said it runs in 3 secs on other servers. Hmmm,
maybe it's the library I'm using as it's still the w2k one... ie

METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"

Anyone know, is there a more recent one for w2k3? Might that be "it"
problem
wise?

I doubt it. The GUID is the same on XP and 2003. Its the same component.

--
Anthony Jones - MVP ASP/ASP.NET
Feb 24 '08 #6
Hmm....got that script up and running ok - but it seems to choke? I properly
put all where the items belong, but when the script hits the oMail.SEND line,
it chokes (my var is oMail for this page btw)?

The logs quite properly show the Script Started and Entering Send lines and
times...but as the script then errors out with nothing more than a 2 line
error --

error '8004020f'
/sendForm.asp, line 135

-- I'm lost. Have no exp using this method to write a timing handler....

Can you offer why the simple addition of this item makes the SEND function
quit before it even starts?

Jim

Feb 24 '08 #7
Ignore what's above....sorry, just can't type today!

Here's the log --

Script Started: 2/24/2008 3:24:42 PM
Entering Send: 2/24/2008 3:24:42 PM
Exited Send:2/24/2008 3:25:15 PM

As you can see, the SEND function worked in less than a second.

So why those extra 48 seconds (as it averages about 50 in total) ???

Jim

"JVRudnick" wrote:
Hmm....got that script up and running ok - but it seems to choke? I properly
put all where the items belong, but when the script hits the oMail.SEND line,
it chokes (my var is oMail for this page btw)?

The logs quite properly show the Script Started and Entering Send lines and
times...but as the script then errors out with nothing more than a 2 line
error --

error '8004020f'
/sendForm.asp, line 135

-- I'm lost. Have no exp using this method to write a timing handler....

Can you offer why the simple addition of this item makes the SEND function
quit before it even starts?

Jim
Feb 24 '08 #8

"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:8C**********************************@microsof t.com...
Ignore what's above....sorry, just can't type today!

Here's the log --

Script Started: 2/24/2008 3:24:42 PM
Entering Send: 2/24/2008 3:24:42 PM
Exited Send:2/24/2008 3:25:15 PM

As you can see, the SEND function worked in less than a second.

So why those extra 48 seconds (as it averages about 50 in total) ???

Is that how you read it? What I see is the send function alone taking 33
seconds to complete. You have placed the "Entrying send" and "Exiting send"
log lines directly adjacent either side of the call to send, right?
--
Anthony Jones - MVP ASP/ASP.NET
Feb 24 '08 #9
good gosh...you're absolutely right! I not only couldn't type yesterday, but
obviously couldn't read a log either!

that mea culpa stated....I agree. 33 seconds is the time it too, and yes the
lines are properly placed around the oMail.SEND line too.

So...why? that's what's got me stumped!

3 seconds on one server and 33 on the other.....

?

Jim

"Anthony Jones" wrote:
>
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:8C**********************************@microsof t.com...
Ignore what's above....sorry, just can't type today!

Here's the log --

Script Started: 2/24/2008 3:24:42 PM
Entering Send: 2/24/2008 3:24:42 PM
Exited Send:2/24/2008 3:25:15 PM

As you can see, the SEND function worked in less than a second.

So why those extra 48 seconds (as it averages about 50 in total) ???


Is that how you read it? What I see is the send function alone taking 33
seconds to complete. You have placed the "Entrying send" and "Exiting send"
log lines directly adjacent either side of the call to send, right?
--
Anthony Jones - MVP ASP/ASP.NET
Feb 25 '08 #10
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:3B**********************************@microsof t.com...
good gosh...you're absolutely right! I not only couldn't type yesterday,
but
obviously couldn't read a log either!

that mea culpa stated....I agree. 33 seconds is the time it too, and yes
the
lines are properly placed around the oMail.SEND line too.

So...why? that's what's got me stumped!

3 seconds on one server and 33 on the other.....

?

Ok so we've established it isn't your script its the SMTP configuration.

Are the speedier servers using the same SMTP server?
Are you using the local SMTP server on the Web Server or another server?
Is it Exchange?
Can you review the authentication requirements of the SMTP server?
Does you script run as the anonymous user or does it use integrated
security?
--
Anthony Jones - MVP ASP/ASP.NET
Feb 26 '08 #11
yes, same SMTP server being used on both boxes

yes, same SMTP setup for both ME and IIS...ie all checkboxes are the same!

not using Exchange at all

authentication is the plain jane MailEnablePro integrated authentication
again on both servers....

script is as follows (without message text which is immaterial) --
=========================================
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
Set oMail = Server.CreateObject("CDO.Message")

Set oMailConfig = Server.CreateObject ("CDO.Configuration")

oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mail.domainname.com"

oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60

oMailConfig.Fields.Update

Set oMail.Configuration = oMailConfig

oMail.From = "ad***@domainname.com"
' from this account which is valid on this server

oMail.To = "jr******@domainname.com"
' this account ALSO on same server and valid too

oMail.Subject = "Website Email Buyer/Seller Form"

MessageBody = "text goes here"
' message is here via request.form from page before...

oMail.HTMLBody = MessageBody

oMail. SEND
Set oMail = Nothing

Set oMailConfig = Nothing

Response.Redirect("thanks.asp")
=================================================
This is pretty simple. Works in 3 seconds on one server and about 40 or so
on the new one.

Why? What'm I doing wrong here...this is SO dang dumb...I'm positive I've
got a simple mistake...but can NOT find it...

Sigh....

Jim

"Anthony Jones" wrote:
Ok so we've established it isn't your script its the SMTP configuration.

Are the speedier servers using the same SMTP server?
Are you using the local SMTP server on the Web Server or another server?
Is it Exchange?
Can you review the authentication requirements of the SMTP server?
Does you script run as the anonymous user or does it use integrated
security?
--
Anthony Jones - MVP ASP/ASP.NET
Feb 27 '08 #12
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:39**********************************@microsof t.com...
yes, same SMTP server being used on both boxes

yes, same SMTP setup for both ME and IIS...ie all checkboxes are the same!

not using Exchange at all

authentication is the plain jane MailEnablePro integrated authentication
again on both servers....

script is as follows (without message text which is immaterial) --
=========================================
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
Set oMail = Server.CreateObject("CDO.Message")

Set oMailConfig = Server.CreateObject ("CDO.Configuration")

oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserve
r") = "mail.domainname.com"
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserve
rport") = 25
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing
") = 2
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconne
ctiontimeout") = 60
>
oMailConfig.Fields.Update

Set oMail.Configuration = oMailConfig

oMail.From = "ad***@domainname.com"
' from this account which is valid on this server

oMail.To = "jr******@domainname.com"
' this account ALSO on same server and valid too

oMail.Subject = "Website Email Buyer/Seller Form"

MessageBody = "text goes here"
' message is here via request.form from page before...

oMail.HTMLBody = MessageBody

oMail. SEND
Set oMail = Nothing

Set oMailConfig = Nothing

Response.Redirect("thanks.asp")
=================================================
This is pretty simple. Works in 3 seconds on one server and about 40 or so
on the new one.

Why? What'm I doing wrong here...this is SO dang dumb...I'm positive I've
got a simple mistake...but can NOT find it...

Sigh....

If you reduce the connection timeout to say 20 seconds does it fail. My
guess it does. The web server is struggling to authenticate with the mail
server. Do both servers belong to the same domain, do they have good access
to a domain controller, is the web server trusted for delegation?
--
Anthony Jones - MVP ASP/ASP.NET
Feb 28 '08 #13
I too believe that there is a "struggle" going on. Both servers are ded
servers from thePlanet and no are not related at all - ie both have diff
clients and domains on them but they both are w2k3/SP2/iis6 boxes. Domain
controller and trusted for delegation are beyond my ken tho...what do you
mean there?

Jim

"Anthony Jones" wrote:
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:39**********************************@microsof t.com...
yes, same SMTP server being used on both boxes

yes, same SMTP setup for both ME and IIS...ie all checkboxes are the same!

not using Exchange at all

authentication is the plain jane MailEnablePro integrated authentication
again on both servers....

script is as follows (without message text which is immaterial) --
=========================================
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
Set oMail = Server.CreateObject("CDO.Message")

Set oMailConfig = Server.CreateObject ("CDO.Configuration")
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserve
r") = "mail.domainname.com"
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserve
rport") = 25
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing
") = 2
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconne
ctiontimeout") = 60

oMailConfig.Fields.Update

Set oMail.Configuration = oMailConfig

oMail.From = "ad***@domainname.com"
' from this account which is valid on this server

oMail.To = "jr******@domainname.com"
' this account ALSO on same server and valid too

oMail.Subject = "Website Email Buyer/Seller Form"

MessageBody = "text goes here"
' message is here via request.form from page before...

oMail.HTMLBody = MessageBody

oMail. SEND
Set oMail = Nothing

Set oMailConfig = Nothing

Response.Redirect("thanks.asp")
=================================================
This is pretty simple. Works in 3 seconds on one server and about 40 or so
on the new one.

Why? What'm I doing wrong here...this is SO dang dumb...I'm positive I've
got a simple mistake...but can NOT find it...

Sigh....


If you reduce the connection timeout to say 20 seconds does it fail. My
guess it does. The web server is struggling to authenticate with the mail
server. Do both servers belong to the same domain, do they have good access
to a domain controller, is the web server trusted for delegation?
--
Anthony Jones - MVP ASP/ASP.NET
Feb 28 '08 #14
thinking here....

could we take this 'off' this forum and converse via email?

let me know if that's okay with you? I've got some results from a component
test and further data on this, but don't want to "hog" any bandwidth for
others...

jrudnick at kkti dot com

:-)

Jim

"JVRudnick" wrote:
I too believe that there is a "struggle" going on. Both servers are ded
servers from thePlanet and no are not related at all - ie both have diff
clients and domains on them but they both are w2k3/SP2/iis6 boxes. Domain
controller and trusted for delegation are beyond my ken tho...what do you
mean there?

Jim

"Anthony Jones" wrote:
"JVRudnick" <JV*******@discussions.microsoft.comwrote in message
news:39**********************************@microsof t.com...
yes, same SMTP server being used on both boxes
>
yes, same SMTP setup for both ME and IIS...ie all checkboxes are the same!
>
not using Exchange at all
>
authentication is the plain jane MailEnablePro integrated authentication
again on both servers....
>
script is as follows (without message text which is immaterial) --
=========================================
<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
>
>
Set oMail = Server.CreateObject("CDO.Message")
>
Set oMailConfig = Server.CreateObject ("CDO.Configuration")
>
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserve
r") = "mail.domainname.com"
>
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserve
rport") = 25
>
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing
") = 2
>
>
oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconne
ctiontimeout") = 60
>
oMailConfig.Fields.Update
>
Set oMail.Configuration = oMailConfig
>
oMail.From = "ad***@domainname.com"
' from this account which is valid on this server
>
oMail.To = "jr******@domainname.com"
' this account ALSO on same server and valid too
>
oMail.Subject = "Website Email Buyer/Seller Form"
>
MessageBody = "text goes here"
' message is here via request.form from page before...
>
oMail.HTMLBody = MessageBody
>
oMail. SEND
Set oMail = Nothing
>
Set oMailConfig = Nothing
>
Response.Redirect("thanks.asp")
=================================================
>
>
This is pretty simple. Works in 3 seconds on one server and about 40 or so
on the new one.
>
Why? What'm I doing wrong here...this is SO dang dumb...I'm positive I've
got a simple mistake...but can NOT find it...
>
Sigh....
>

If you reduce the connection timeout to say 20 seconds does it fail. My
guess it does. The web server is struggling to authenticate with the mail
server. Do both servers belong to the same domain, do they have good access
to a domain controller, is the web server trusted for delegation?
--
Anthony Jones - MVP ASP/ASP.NET

Feb 28 '08 #15

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

Similar topics

0
by: ptouch | last post by:
Hi, I am using Python 2.3.4 with Windows 2000. It is a Pentium Xeon 2GHz with 1GB of RAM. As the title says, importing most modules takes about 2 to 3 seconds. Also, starting the interpreter...
4
by: Karaoke Prince | last post by:
Hi There, I have an update statement to update a field of a table (~15,000,000 records). It took me around 3 hours to finish 2 weeks ago. After that no one touched the server and no...
2
by: serge calderara | last post by:
Dear all, I have a simple class in my application whcih create dynamically textbox control to be place on a form When I execute the code : log(time) my control = new myclass() log (time)
0
by: JJ | last post by:
Hi, I'm having a little problem. I use the following code to open a .pdf file from one app. : System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo(); string path...
1
by: mike | last post by:
Hi, Starting a debug session used to take about 2-3 seconds. I took the project home and worked on my laptop at home, burned it onto CD then brought it back to work. Now it takes 15-20 seconds...
1
by: mike | last post by:
Starting a Debug used to take 2-3 sec and now takes 15-20 seconds. This happened after working on the project at home, burning to CD and bringing back to work. I've changed all folder/file...
4
by: Brian | last post by:
Hello, I have a vb.net web app that I am doing reads and adds to a database. Everything works fine and happens instantly. I recently added an update and it takes a long time to finish. I was...
1
by: William Sullivan | last post by:
I've got a website that may, on occasion, display a large list of items in a bulletedlist control. On the client side, it takes about 4 seconds to get a response that weighs in at over 1mb. It...
2
by: Jason Huang | last post by:
Hi, I am wondering why it takes a long time to open an .aspx file at the first time in a browser. Are there some methods to improve that speed? Given that we are using the IIS5+VS2005 C#....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.