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 !