Seems to me that the Locate method is responsible for the slowdown , the
keyspace grews larger with each iteration. Maybe segmentating the
searchspace you could get a boost in perfomance. If you have the data
ordered , maybe you can use a more fast comparasion to ascern if the key
needs to be created. But I may be wrong.
Just wanted to help.
Mort.

----- Original Message -----
From: John Hart
To: IBObjects@yahoogroups.com
Sent: Wednesday, February 20, 2002 11:52 AM
Subject: Re: [IBO] Digest Number 874
[SNIP]
if qResult.FindFirst then
repeat
sKey := BuildKey; //Build the Key
if qPool.Locate('KEYSTRING',sKey,[]) then qPool.Edit