Err sorry Erin I forgot to ask the size of your table.

10 secs for a seek is almost unheard off.

something else must be going on


>
>1. SELECT (table alias)
> LOCATE FOR ;
> (table field) = (variable)
>
>This one takes 10 seconds.
>
>2. SELECT (table alias)
> SEEK (variable)ORDER (table field)
>
>This one also takes 10 seconds.
>