Formula Fill Timing Issue

[David Thompson]

>  >The lookup db had 27,000 records with 269 fields. I formulafilled a
>>db with 10,000 records. In the first test, the key field was the
>>first field, the data field was the last. Total elapsed time: 135
>>seconds.
>>Then, I moved the key field to column 50. Total elapsed time: 389 seconds.
>
>That increase apparently is due to the key not being the first
>column. I'd like to hear what the results would be if the key was
>first and the data was 2nd.

There would probably be some effect, but it wouldn't be nearly as 
great. Assuming the average lookup finds a match in the 13,500th 
record (half of 27,000) then during the course of the formulafill, 
values would have to be fetched from the key field 135,000,000 times, 
while values would be fetched from the data field 10,000 times. 
That's a ratio of 13,500/1.

Dave