Hi
Try the query with an index on pcode_n10 column.
The speed depends very much on index selectivity.

>Hi! My group and I are trying to benchmark the speed of the product we are currently developing. With just 10,000 records, this query runs pretty fast (by the way, we are trying to use the visual foxpro database for faster distribition and installation)
>
>select * from p_optal where pcode_n10=thisform.pcode_n10.value order by date_d desc into cursor temp_pcode
>
>and we tried to estimate the operation of the business using the software. We computed that in a period of 5 years, the table can have as much as 650,000 records and we encountered a slight problem in speed. It takes about 10-15 seconds to get the result using the same query i stated above. 10-15 seconds is a lot of time wasted for the operations, would any of you have a suggestion as to how we can speed up the process? Thanks and more power to the Fox!