Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why this DELETE is so slow?
Message
 
À
23/02/2005 18:28:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
00988740
Message ID:
00989894
Vues:
83
>>Per #2 or #3.1 in Message #989852
>>

>Which one are you interested in in you particular case?

In my particular case that's irrelevant because I do not really have a "filter" condition so it doesn't matter to me if "in theory" it is doublechecked.
DELETE FROM Resource WHERE TaskId IN (SELECT Id FROM Task WHERE Task.MainId=12345)

But if by "my case" you mean how I try to use VFP, then probably 3.1 would be my default. But I would lo-o-o-ve to have a SET command for it.

BTW, How's that for a level #4, "Serializable transactions"?
"DBLOCK()" is applied before any UPDATE or DELETE command. This is *very* slow but ensures that the scope is guarantied for the duration of the command.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform