>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-
>===============================================
Myron,
Thanks for the reply. Your example does sound like the same thing that I am trying. I also get immediate results, but only with deleted off. With deleted on, I get 7+ seconds turn around. And I do a CLOSE ALL CLEAR ALL, ect... after each test.
I also turn on SYS(3054, 1) and it tells me that the SELECT is using the deleted tag and the other key tags. Will it help if I create a tag on !DELETED()?
Thanks,
Jerryt
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement