Jerry,
There are the other non-FoxPro variables such as the network,
other jobs requesting data from the server. Also, where are you
temp, sort, and work files mapped to.
I ran a similar test on a table that has 120,000 records. It has a tag
on DELETED. Also, SET DELETED is ON, SET ANSI is OFF. I did the following
select:
SELECT;
*;
FROM Chg_Hist;
WHERE Chg_HistId = [000001333];
INTO CURSOR crsMlk
On the above I received nearly an instant response. I am running
on a local database.
-myron kirby-
===============================================
>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