Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this DELETE is so slow?
Message
From
21/02/2005 15:33:44
 
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:
00989002
Views:
47
>No difference
>
>It runs slow if all 3 of these conditions are present:
>1. It involves nested SELECT
>2. The files are open in at least one more VFP session
>3. No FLOCK is issued on the file being updated (or deleted from)
>
>Why?

This is a interesting issue.
On my last post, the nested SELECT is a exclusive cursor,
then the nested table is out.

Point 1.
* try
BEGIN TRAN
DELETE ..... JOIN ....
END TRAN
Point 2. Simulating this with 2 cursors,
the Rushmore report print a Intermediate optimization step,
but i don't look this into your Rushmore report.

Point 3.
The Deleted table is a local table or a LAN table ?
Can you do the job into the table's machine ?

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform