What is quicker: delete for or DELETE where? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What is quicker: delete for or DELETE where?

Message

De

11/09/2006 19:43:58

Naomi Nosonovsky
Wisconsin, États-Unis

À

11/09/2006 16:00:59

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: What is quicker: delete for or DELETE where?

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP

Database:

Visual FoxPro

Divers

Thread ID:

01152861

Message ID:

01152900

Vues:

22

>If you don't have an index, VFP will have to scan whole table regardless what you do. DELETE-SQL will be even slower because it'll lock/unlock each record.
>
If I add the index, what would be better?

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform