| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 and hence may be faster.
Nothing wrong with that.
Raj
-----Original Message-----
From: Craig Healey [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 13, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Performance improvement required :-)
It's Friday, and I'm having a brain storm. Just to check: The developers are using ADO to connect to a VB application and want to pull back a record set. Using ADO means they can't use bind variables. Returning more than 1 record means they can't use a function (which WOULD use bind variables). Am I correct in saying that other than tuning the SQL (done that, it isn't a complex query) or playing around with Oracle session parameters, there isn't anything else I can do? (The query takes 1 second the first time it is run, but 10 ms after. It is used all the time in the callcentre to search postcodes.)
TIA Craig Healey
********************************************************************This e-mailmessage is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank
you.*********************************************************************2Received on Fri Jun 13 2003 - 10:02:12 CDT
 |
 |