Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this DELETE is so slow?
Message
 
 
To
23/02/2005 02:08:56
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:
00989552
Views:
66
>Hi Andrew,
>
>>I do have one more question on this. In my experimenting, I set REPROCESS to, say, 3 sec and did *not* receive an error when the record in the "filter scope but not in the join scope" was locked by another VFP instance. This is *not* how locking usually works, as it would normally report an error when it "really wants" to lock a record and can't. Is this by design? Or am I seeing things?
>>
>
>The error will be reported if the record should be deleted.
>

Aleksey,

If this lock isn't required anyway, why not eliminate it altogether and lock record before deletion only?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform