<snip>
>>>Can you please provide more details? Especially, what is the SQL - SELECT command, and what index(es) you have?
>>>
>>>Hilmar.
>>
>>In this case I have a table with about 1.2 million records.
>>I have a character field which as a width of one called RampCode.
>>I have one index only on the RampCode field.
>>As a pre-digest idea, I was going to store the values into this table so that
>>my Sql would be basically like this.
>>

>>Select * From VinData Where RampCode = lcRampCode Into Cursor qDetails NoFilter
>>

>>This takes approximately 21 seconds. I've updated the time from 27+. That was with SET DELETED ON.
>
>I just did some testing on my own.
>
>Jim is completely right - you save a lot of time by NOT including all fields.
>
>Apart from that, I can only say that you are indeed giving Visual FoxPro a lot of work, perhaps unnecessary. Do you really need the 20,000 records? Or rather a summary calculation based on them? In the latter case, it may or may not be feasible to have summary records in separate table(s).
>
>Hilmar.

Actually, in this case they want to see all the details but paged 20 at a time.