473,626 Members | 3,531 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2074
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*******@disc ussions.microso ft.comwrote in message news:F5******** *************** ***********@mic rosoft.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*******@disc ussions.microso ft.comwrote in message
news:F5******** *************** ***********@mic rosoft.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*******@disc ussions.microso ft.comwrote in message
news:CE******** *************** ***********@mic rosoft.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.Session ID & ".log")
Dim fso : Set fso = CreateObject("S cripting.FileSy stemObject")
Dim oStream: Set oStream = fso.OpenTextFil e(sPath, 8, True)

oStream.WriteLi ne "Script Started: " & Now

'Code building message in oMsg

oStream.WriteLi ne "Entering Send: " & Now

oMsg.Send

oStream.WriteLi ne "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*******@disc ussions.microso ft.comwrote in message
news:CE******** *************** ***********@mic rosoft.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.Session ID & ".log")
Dim fso : Set fso = CreateObject("S cripting.FileSy stemObject")
Dim oStream: Set oStream = fso.OpenTextFil e(sPath, 8, True)

oStream.WriteLi ne "Script Started: " & Now

'Code building message in oMsg

oStream.WriteLi ne "Entering Send: " & Now

oMsg.Send

oStream.WriteLi ne "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*******@disc ussions.microso ft.comwrote in message
news:8C******** *************** ***********@mic rosoft.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*******@disc ussions.microso ft.comwrote in message
news:8C******** *************** ***********@mic rosoft.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

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

Similar topics

0
1140
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 takes 2-3 seconds (I think at the time it tries to import site) The variable sys.path seems like the default compiled-in one.
4
18172
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 configuration changed. Until yesterday, I re-ran it again and it took me more than 18hrs and still not yet finished!!! What's wrong with it? I can ran it successfully before. I have tried two times but the result was still the same.
2
1666
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
3002
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 = @dir+"\\"+myDataTable.Rows.ToString();
1
1417
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 to start a debug session. Anyone have any ideas on what could've caused this. (By the way, I already went in and removed the "read-only" status of all folders/files that resulted from the CD.)
1
1676
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 permissions to allow full read/write. Any ideas? Mike
4
2058
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 wondering if there was anyone else who experenced this problem and if there are any ways around it? Dim MySQL As String MySQL = "UPDATE db SET Var1 = 'Y' WHERE aimtno = " & tnum & " and abook = " & tbook Dim strConn As String =...
1
1935
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 takes less than a second to display those nodes. That part is fine The problem is that when the user causes a postback, the browser appears to lock up for anywhere between 10-20 seconds, at which point it renders the response from the server. ...
2
1543
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#. Thanks for help. Jason
0
8266
marktang
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...
0
8199
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8705
Oralloy
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...
0
8638
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8505
tracyyun
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...
0
7196
agi2029
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...
1
6125
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5574
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();...
0
4092
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 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.