Re: Delphi/Oracle Database Perfromance - Order By Problem

Edward J Hooper wrote:
>
 

> REPORT ON BORLAND DELPHI/ORACLE PERFORMANCE PROBLEMS
> Friday, August 16, 1996
>
 

> 4. CONCLUSION
> We believe that the performance problem is caused by the order by clause
> on the time_enter field in the main query used to access the doc table.
> Although the time_enter field is indexed, the index does not appear to
> be being used, instead Oracle is doing a full table scan to fulfill the
> order by.
> We need to find a way to force the index to be used, so that the data is
> returned immediatley.
> We are using delphi ttable components, and have no means of optimizing
> the SQL statement produced by the component, so we hope the answer lies
> within the Oracle database.
>
> We feel that there must be a straightforward solution to this problem
> hopefully avoiding any re-coding of COMM1.
 

> Edward J Hooper

I am doing research connecting a webserver and delphi 2.0 on an NT server with Oracle 7.2 and 7.3 on a Dec Alpha UNIX platform and a mainframe. I have good performance between delphi and oracle. I use the delphi explorer to connect and run the sqls before I place them in the code for use in the cgi. We have found that using the TQuery component provides much faster performance than ttable.

-- 
George Zolla   gazolla_at_nps.navy.mil