Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it reasonable to have index on DELETED()?
Message
De
15/03/1999 02:55:02
Walter Meester
HoogkarspelPays-Bas
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00196021
Message ID:
00197514
Vues:
21
David,

Though i know that an index on deleted will help you to get full optimization, it gives no garantee that the general performance will increase. I've the impression that the pressure to use an index on deleted() is not based facts, but on the goal to have full optimization, by which (in my opinion) users are mislead.

If you've an index on deleted VFP has to maintain an extra index which leads to decreasing performance when you insert or update records in a batch.

Second, If the table you're searching in does not have many deleted records, the gain of performance would be very small. In my apps i never have many deleted indexes in large table for two reasons.
1 - it takes valuable disk space (2 GB limit)
2 - it decreases performance, even if you have an index on deleted() because of the larger table.

Now i can hear you say, but i can't schedule a pack procedure because the system runs 7 days a week. But even then you could recycle deleted records.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform