>I expect the table to grow pretty large - over 1 million records. In general...what is faster - a LOCATE or SELECT SQL statement for locating a single record?
>
>Thanks,
>Doug
Doug,
The fastest way for locating a sinle record is
SEEK assuming that you have appropriate index.
--sb--