Hi Jerry.

After reading this post I thought that I should check our data since I am rewriting an application to Visual Foxpro 5.0a from FoxPro DOS 2.6.
I found some interesting results that are similar to yours. Maybe someone can comment on them.
I used an 860,000 record table to do the test on. Copied out deleted records. Created fresh tags on deleted() and Ctrlno. Tests running through Win98 even the FoxPro DOS test. Average time of 100 selects.
Select statement used:
select * from CHECKS where CTRLNO = "86112378" into cursor csrTEMP

FoxPro DOS 2.6
set deleted on: 0.08 set deleted off: 0.06
not bad.

Visual Foxpro 5.0a
set deleted on: 3.50 set deleted off: 0.06
oh my!

Here is the interesting one. I removed the tag on deleted() and deleted 5000 records in the table.
Visual Foxpro 5.0a
set deleted on: 0.05 set deleted off: 0.04
Huh??

Anyone have any clues, suggestions, comments, or anything???

-Michael M. Emmons

>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