Re: Performance Problem: Delphi 2.0 and Oracle

troy.sorzano_at_adic.ipu.com (Troy Sorzano) writes:
> Ingi Steinar Ingason <isi_at_itn.is> wrote:
>
>
> >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!

First, the first time you set up a TQuery or TTable you will see a big performance hit because it needs to load up lots of information. However, once loaded, you can reuse the TQuery or TTable very efficiently. I suggest minimizing the number of TTables and TQueries you have.

We were using the TDBLookupCombo, a nice idea, but two queries per component can add up quite fast. And with each TQuery taking approximately 2 seconds to load...We we were waiting a while. We decided to set up one query per table in the database (where info is stored), use one query for all TCombobox's to load the information into the TComboBox.items manually in code. We store the data ourselves too. This reduces the database overhead immensely. You can do similar actions with TEdit, TListBox, etc.

I hope this is a help. Received on Wed Apr 10 1996 - 00:00:00 CEST