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
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
