>Hi Peter,
>
>Take out the "into array" clause of the SQL statement and compare again. No fair timing the creation of an array for the SQL-SELECT part of the test. <g>
>
Re:
> select cName from SEEKTEST ;
> where SEEKTEST.iOWNERS = lnKey ;
> into array laName
> endfor
I'll try some variations. Were you thinking that select into a cursor/table would be faster or slower than this?
>Also, try the new INDEXSEEK(), which doesn't move the record pointer (as SEEK() does), Am curious to see how it does.
>
>Susan
Don't have V6 yet, but it sounds good.
Peter
Peter Robinson ** Rodes Design ** Virginia