Re: Performance Problem: Delphi 2.0 and Oracle

In article <316B0DE3.5298_at_ms2.hinet.net>, edwardc_at_ms2.hinet.net says...
>
>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

I'm having the same type of problem with Delphi 1.0 and Interbase. VERY slow, and VERY frustrating!

Rich Received on Wed Apr 10 1996 - 00:00:00 CEST