Subject Re: [IBO] large lookup table problem
Author Helen Borrie
At 02:42 AM 28/06/2003 +0000, you wrote:
>large lookup table problem
>I have a TIB_lookupcombo setup. during the insert or edit mode when
>the TIB_lookupcombo is being used I feel like it is very slow since
>the Lookup table is very large ... Any suggestion or guidelines to
>improve its performance?

Yes: if you can't restrict it by a WHERE clause then don't use it for this
interface. 200 is about the maximum useful size of a drop-down lookup.