-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Pardee, Roy E
Sent: Friday, June 13, 2003 20:10
To: Multiple recipients of list ORACLE-L
Subject: ADO and bind variables (was RE: Performance improvement
required :-))
This is interesting--if I use
Why can't you use bind variables? I thought using .Parameters method
(property?) of ADODB.Command would use bind variables.
What function, and where can't you use it?
-Original Message-
Sent: Friday, June 13, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
It's Friday, and I'm
Title: RE: Performance improvement required :-)
Craig,
any query when run first time will take more time, because it has to do _all_ the work, i.e. do physical reads. Subsequent executions usually benefit from finding the required data blocks in buffer cache, thus minimizing physical reads
Just guessing, but it seems as if the longer initial run is because the
data is being pulled into the buffers. After that the query is being
answered without disk i/o. See if you can cache the table and if that gets
rid of the initial long run.
Why can't you use bind variables? I thought using .Parameters method
(property?) of ADODB.Command would use bind variables.
I thought it didn't. Any way of checking (other than to get the
developers to try it?
What function, and where can't you use it?
Stored Procedure type function
Using REFCURSOR you can return result set from stored procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Craig Healey
Sent: 13. júna 2003 12:20
To: Multiple recipients of list ORACLE-L
Why can't you use bind variables? I thought using .Parameters method
I'm sure you can. You should see it in an ODBC trace log, or you can
use trace events on the database. Here's a really simplistic test I did
to verify it. I ran this VB code that executes a really dumb query that
could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE
DUMMY = 'X'
This is interesting--if I use ADO with the ODBC provider (as the code does
below), I get the same results. But if I use just ADO (that is, ms' OLE DB
provider for oracle (MSDAORA.1)) then I don't get bind vars.
(I'm doing INSERTs in my code, not SELECTs).
I wonder if oracle's native OLE DB
