Why this DELETE is so slow? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Why this DELETE is so slow?

Message

De

20/02/2005 22:24:39

Andrew Solgan
Santa Cruz, Californie, États-Unis

À

20/02/2005 21:44:42

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Why this DELETE is so slow?

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:

00988754

Vues:

29

Actually this is what I see:

Open 1st instance of VFP
Execute DELETE - runs fast

Open 2nd instance of VFP
USE the 2 tables

Back into the 1st instance
Execute DELETE - slow

Close the 2nd
In the 1st run DELETE - slow !!!
Reopen tables
Run Delete again - fast

What's going on?

Click here to load this message in the networking platform