Does the SQL trace monitor reveal anything?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <rvellacott@...>
To: <IBObjects@yahoogroups.com>
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.