Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this DELETE is so slow?
Message
 
To
23/02/2005 18:28:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00988740
Message ID:
00989894
Views:
92
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform