I import a Spreadshhet 'into' a tiboquery.

If I have the TIBOQuery with cached updates = true ( to increase
performance ) but I also want to check as I insert each record there
is not already a duplicate key - what can I use besides the Locate
function ?

If the cached updates = true does the Locate do a fetchall or will it
just look at the cached records ?

The table I insert records to is always cleared before each import,
so the locate really only has to look at the current transaction.

I don't want the locate to do any unnecessary actions as performance
is critical.

Thanks

Rod