Subject Re: [IBO] Performance of Locate

When FetchWholeRows is true, the first Z search takes (nearly) as
long as the third one. But thereafter I can locate on the entire
table with no delays.

Fetching whole rows is especially slow because I have some heavy
querying going on to populate some CalculatedFields.

Don't forget that I have solved the problem by calling RefreshKeys
before each Locate. I just wondered whether this was the right way to
do it.

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> Set FetchWholeRows to true and see what it does.
> --
> Jason Wharton
> CPS - Mesa AZ