Re: Performance Problem: Delphi 2.0 and Oracle

Ingi Steinar Ingason wrote:
>
> Hi there!
>
> I am creating an application with Delphi 2.0 (Client server Suite) and
> Oracle7 using the Oracle SQL link and the BDE.
>
> In the Beta version of Delphi 2.0 opening a table in an ORACLE database for
> the first time in an application took up to 2 minutes, but since there was
> some talk about the SQL links would be optimised we did not worry about
> this. Opening tables with master-detail connections and lookup fields
> seemed to be especially slow. BUT when we got the final product we saw
> that the performance had not improved AT ALL!
> So we put our db into trace mode and found out that the BDE was doing some
> strange stuff, selecting lots of things from the data dictionary, about
> constraints, columns, nullable columns and indexes for all the tables,
> total of five statements for each table opened, not including the real
> fetching of data. Some of these statements took up to 15 secs since the
> got into a full table scan on the system tables (sample below).
> Selecting this data is something one would think the BDE should not need at
> runtime, and to test this we tried dropping some of the system views these
> statements used and put instead identical empty tables, for example we
> dropped sys.dba_constraints, and (surprise, surprise) this did not have any
> affect on Delphi (EXCEPT for a great improvement in speed).
>
> So my questions are:
> - Why is Delphi selecting all this data when it does not need it at all?
> - Are there any options I could change in the BDE Config or in some other
> way to stop the BDE from selecting this data.
> - Has anyone had this problem and found a solution for it?
> - Does anyone have any ideas he/she would like to share on this matter?
> - Why is this only a problem in Delphi 2.0 (the old 16 bit worked fine)?
>
> Any help would be greatly appreciated!
>

I had the same problem ! Is there any solution ? I am appreciated to hear that !

Edward Chen Received on Wed Apr 10 1996 - 00:00:00 CEST