Subject Re: [IBO] Performance of Locate
Author Jason Wharton
Does the SQL trace monitor reveal anything?

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: <rvellacott@...>
To: <>
Sent: Friday, October 12, 2001 7:04 AM
Subject: Re: [IBO] Performance of Locate

> Jason,
> 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.