Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why this DELETE is so slow?
Message
De
21/02/2005 15:33:44
 
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:
00989002
Vues:
56
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform