Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xbase commands Vrs Sql commands
Message
De
08/05/2005 15:55:06
 
 
À
07/05/2005 11:26:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
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 6 SP5
Database:
Visual FoxPro
Divers
Thread ID:
01011885
Message ID:
01012036
Vues:
28
>For example check Thread #1011797
>It's a sample where SQL is faster.

At first glance I'd also say, that sql is better
for doing such mass data processing.

But I'm missing the xbase variant of that update
to really proof that sql is faster here.

The initial though was, that an sql update should
be faster than a scan loop. It was never thought of
the power of SET KEY TO to scan through the portion
of the data of a month or an agent with the appropriate
index, which could even win over the sql update.

Bye, Olaf.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform