On Wednesday 05 May 2004 21:18 pm, Stacy Young wrote:
See Oracle technet for additional info!
Do you have a reference ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Reference for what, specifically?
The URL for technet is: http://otn.oracle.com/index.html
-Jason Gulledge
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 9:10 AM
To: CF-Talk
Subject: Re: RESOLVED - FYI : Oracle 9i and cfqueryparam
Wow, folks using CF for reporting w/ Oracle DBs should re-evaluate the
use of using bind variables. For transactions and the like they are fine
but in the case of reporting, bind vars can wreak havoc.
The over simplified explanation is that bind variables can inhibit the
work of Oracles optimizer
the parsing, etc.
We've proven the above theory in many instances.
Hope that helps!
Stace
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 10:41 AM
To: CF-Talk
Subject: Re: RESOLVED - FYI : Oracle 9i and cfqueryparam problems
table scans on enormous
tables. (tens of millions of rows)
-Stace
_
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 12:21 PM
To: CF-Talk
Subject: RE: RESOLVED - FYI : Oracle 9i and cfqueryparam problems
Wow, folks using CF for reporting w/ Oracle DBs should re
to use.Its *VERY* helpful.
Jason
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:15 PM
To: CF-Talk
Subject: RE: RESOLVED - FYI : Oracle 9i and cfqueryparam problems
We use bind variables extensively as well. The only case in which they
can cause
To: CF-Talk
Subject: RE: RESOLVED - FYI : Oracle 9i and cfqueryparam problems
You know, we do something VERY similar...we partition by month... I do a
check at execution time because everytime someone queries the data its
for a given month...and the month just so happens to coordinate
Wow, folks using CF for reporting w/ Oracle DBs should re-evaluate the
use of using bind variables. For transactions and the like they are fine
but in the case of reporting, bind vars can wreak havoc.
The over simplified explanation is that bind variables can inhibit the
work of Oracles
: Oracle 9i and cfqueryparam problems
Wow, folks using CF for reporting w/ Oracle DBs should re-evaluate the
use of using bind variables. For transactions and the like they are fine
but in the case of reporting, bind vars can wreak havoc.
The over simplified explanation is that bind variables can
,
Stace
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 4:32 PM
To: CF-Talk
Subject: RE: RESOLVED - FYI : Oracle 9i and cfqueryparam problems
It was my understanding (and I could be wrong) that if you were using
hints in your select statements to force
10 matches
Mail list logo