>>>>ON a P-166 Mhz , 32 Mb Ram , a combo whose rowsource file has 6000 records , takes 30 seconds to reach the records with letter 'S'.
>>>>
>>>>Could somebody help in optimising speed. Does VFP work so slow with just 6000 records (4 MB File)
>>>>
>>>>Thanks
>>>>
>>>>Pankaj
>>>
>>>Firstly, it's common interface consideration to use Combo for smaller recordsets and Grid for larger ones. The real speed depends on VFP version you use and Rowsourcetype setting.
>>
>>Edward,
>>What do you consider the fastest rowsourcetype? My boss always uses arrays, which don't seem to be the best choice to me. Especially when dealing with a lot of rows. Thanks.
>>
>>Marcus.
>
>I don't have much experience here, because I avoid using combo for large number of items, and it's impossible to discern what is faster for smaller number of items. My guess is that cursor.field is the fastest rowsource.

Thanks for your reply. I realize the original question was about combo boxes, but I was actually thinking more along the lines of list boxes. Specifically, Rowsource of Array vs. SQL vs. creating a cursor and using ALIAS. I should probably take this question to a new thread. Thanks.

Marcus.