Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Codage, syntaxe et commandes
Hi CY,
>And a caviat recently found. If you have index tags on deleted() on your tables, Access has trouble dealing with the tables (sometimes).
>We have such a tag on EVERY table in our product,
Why ???
those indexes on tables actually have bad influence on performance in the vast majority of cases. It is a common mistake to think that an index on DELETED() would speed things up.
>I have also seen some benchmarks in either Foxpro Advisor or Foxtalk (can't remember which right now) that imply that having a tag on deleted() may actually slow queries down unless you have a LOT of deleted records in your data all the time.
FPA may issue. And they're right. You'll probably will improve performance of your application if you'll omit them. If it runs on slower networks, the performance gains might be tremendous.
Walter,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement