>Cy,
>Are you saying that ASCAN() is faster than Seek()?
>
>Barbara
>
>
>>I have found that where I need to recursively hit a lookup (sometimes ones that are dynamically created based on the user) that its MUCH faster to bring it into an array, and do ASCAN's to get the row I need. Many times I have seen speedups that appear to be factors of 4 or higher.
It appears to be that way to me. I don't have any empiricle (sp) tests, but that is my impression when I have done it. I may have to be with it being faster to read the elements than to actually read the fields from the table.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc