Formula Fill Timing Issue

[Robert Ameeti]

At 6:00 PM -0500, 2/9/08, Mark Terry wrote:

>>The further the data column is from the key column, and the further 
>>either of them are from the first column, the longer the lookup( 
>>time.

>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.
-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

I can remember when the air was clean and sex was dirty.
            -- George Burns
<><><><><><><><><><><><><><><><><><>