Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Index
Divers
Thread ID:
00607646
Message ID:
00607646
Vues:
59
Hi!

I've tested the database performance, creating the index::
INDEX ON DELETED() TAG MyTest
The performance was great when I use the databases in just one computer. When I use in multi-user, the result is terrible.

I'd like to know if the problem happens because I was using a function (DELETED()) or because I have just two results (.T. / .F.)?

If I have a field SEX (C) 1 where I have just 2 values too (M and F), but I don't use a function, the problem happens or not? Should I index this field?

[]s
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform