>I have 1 table that has 130,000 records. I have an DELETED() tag on this dbf.
>
>With SET DELETE ON, the following query takes 7+ seconds. With SET DELETE OFF, the query takes .25 seconds. Only 1 record is being selected from the table and there is a tag on the part field.
>
>select myfile.part ;
> FROM myfile ;
> WHERE myfile.part = "440" ;
> INTO CURSOR test
>
>SYS(3054, 1) says that the part tag is being used and the deleted() tag is being used and that the optimization level is FULL.
>
>Should this query take 7+ seconds with DELETED ON and .25 with DELETED OFF?
>
>Thanks,
>
>Jerryt
That's Ok, just note that proper bench test should include reloading of VFP after each query. Also, if you need just one record then SEEK will give you even better results.
BTW, do you have tag on'part'?
Edward Pikman
Independent Consultant