[thelist] (ASP) Connection time measurement

Tab Alleman Tab.Alleman at realmetros.com
Wed May 15 09:17:01 CDT 2002


Oh yeah I forgot about that problem.. I learned it the hard way, and you
actually had the foresight to think of it in advance...I hate guys like
you.  :)  I put something like this in my code:

	If t0 > t1 Then t1 = t1 + 86400 'midnight



-----Original Message-----
From: Amazon Paulo [mailto:Amazon.Paulo at amazoniacelular.com.br]
Sent: Tuesday, May 14, 2002 5:15 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] (ASP) Connection time measurement


Thanks, Tab, it works fine.

I put in the code two variables: t0 and t1. They will store the timer
value before and after the connection.open method.

Just wondering: what would happen if t0 is 11:59:59 pm and t1 is
00:00:01 am ? Would "t1-t0" return 2 seconds?

Paulo

-----Original Message-----
From: Tab Alleman [mailto:Tab.Alleman at realmetros.com]
Sent: Tuesday, May 14, 2002 6:00 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] (ASP) Connection time measurement


Try putting Timer()'s before and after you open the connection and
compare those.  They measure time in milliseconds, so they're more
accurate.

-----Original Message-----
From: Paulo Guedes [mailto:ramone at amazoniacelular.com.br]
Sent: Tuesday, May 14, 2002 4:27 PM
To: thelist at lists.evolt.org
Subject: [thelist] (ASP) Connection time measurement


Hello,

I've been lurking for a while and this is my first mail to this list. I
hope someone can help me.

We have a huge application running on a IIS4 server. This app was not
developed by me, so I'm fixing up some errors I found and trying to
prevent some other errors.

One of the most common problem we have is when the connections to our
Oracle 7 database take too much time to open. Because we have too many
users and every page opens a new connection, more than one second will
be "too much time to open".

I'm wondering how I can measure whether these connections are taking too
long to open.

The basic code to do this is:

(...)
on error resume next
conn.ConnectionTimeout = 5
conn.open "xxxxx", user, pass

if conn.State = 0 then
    set conn = nothing
    Response.Redirect "errorpage.asp" ' tells the user that could not
open the connection end if
(...)

I would like to know exactly how much time the connection took to open.
I've noticed that putting a line " t = time " before the Open method and
comparing " totaltime = time - t " does not work fine...

Cheers (and sorry if my English is too poor...),
Paulo Guedes

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !



More information about the thelist mailing list