Thanks Brian, I figured out the answer. in sql +, you write "set timimg on" and after that, you can type in a query and it will return the time to execute. Now my question is should the driver take half a second to carry the query over? When I do select sysdate from dual in a cfquery, it takes almost half a sec repeatedly. When I do it in sql+ it starts at 40ms and goes to zero with a few tries. I think this is unacceptably long? Anyone seen this? Tks DRE
-----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 5:07 PM To: CF-Talk Subject: RE: oracle get tick count? Don't know the exact answer to that, but you might try this... If you are using TOAD to interface with Oracle then use the EXPLAIN PLAN (the little ambulance) to help you find what is using indexes and what order the statements occur in. Also, you can get information on the server and it's processes/times through SERVER STATS under the TOOLS menu +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 3:34 PM To: CF-Talk Subject: oracle get tick count? Hey Gang, I'm plunking away at this large app we created for an accounting group. When 2 people use it, it works ok, When 4 people use it, it slows to turtle speed. Its all on an intranet so network speed shouldnt be an issue. p3 800 or so with 512 ram, w2000, cf5, big ole oracle machine. Weve got all the switches set according to mm tech support with trusted cache set to 5x app size. Lots of cached queryies etc, But, let me get to my question. Were growing suspicious of the native driver as being part of the culprit. Anybody have experience with these? thumbs up or down? If down what options and what benefits? Either way, I want to compare apples to apples and get comparable db recordset return times. So, in a simple cfm page, i embed a single cfquery and run it to see how long it takes to come back via the debug info. How can I do this in sql+ ? Basically the equivalent of gettickcount() <query goes here> gettickcount()? Oracle gurus? Please help. Thanks. DRE -----Original Message----- From: James Curran [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 3:42 PM To: CF-Talk Subject: RE: Force Pop-Up Window Use javascript in the popup to set the field value of a hidden field and don't give them an option to enter into a text field. - j -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10:31 AM To: CF-Talk Subject: OT: Force Pop-Up Window I am using a pop-window for date entry for my application. Does anyone know of a way to force users to use the pop-up? I want to prevent users from keying in a date via keyboard. James ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
