Subject Re: [IBO] How to avoid lookup table from fetching all records ?
Author Geraldo Lopes de Souza
"Harald Klomann" <nibler@...> escreveu na mensagem
> > They are false already. If I set KeySeeking to False It doesn't fetch
> > records, and the lookup doesn't work too...
> >
> > Thanks in advance
> Geraldo,
> are you shure, that all records of the lookup dataset are fetched ?
> Normally, by opening the main dataset, a bunch of records are fetched
> from the server, depending on your settings. For each of this records,
> there will be a fetch to the lookup table - but only, if the record
> to be fetched doesn�t exist in the buffer. So please check, how many
> records exist in your lookup table and how many of the are fetched
> after opening the main dataset.

BufferRowCount of Main dataset 10 records
BufferRowCount of lookup dataset 17960 records

I know I could establish a master detail relationship to achieve the same
result and still be capable of making search. The problem is that the search
would be based on EXISTS clause which isn't very fast.

Thanks in advance

Geraldo Lopes de Souza