Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slooooooooooow UPDATE
Message
De
03/08/2010 14:20:39
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Slooooooooooow UPDATE
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01475043
Message ID:
01475043
Vues:
105
Howdy all --

I have just recently learned of UPDATE-SQL and am now trying to use it. There's something I have missed, however, because the following executes really slow ... a minute or more to execute!
Update  KitDetail Set												;
		  ReceivFlag = .T.											;
	From c_TransferDetail											;
	Where c_TransferDetail.Received									;
		And c_TransferDetail.NonInvID = KitDetail.UniqueKey			;
		And KitDetail.UniqueKey # 0
KitDetail is table indexed by UniqueKey.
c_TransferDetail is a cursor with maybe 20 to 50 records in it.\

Previously, I handled this with SET RELATION into KitDetail, and it completed essentially instantly.

OK, so what am I missing here?

Thanks so much in advance,
Jim Nelson
Newbury Park, CA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform