Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Should I add DELETED() tag
Message
 
 
À
15/05/2001 05:16:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00507170
Message ID:
00507182
Vues:
27
Hi!

I guess yes. However, why not PACK thais table so deleted records go away? Common practice is making the service running at the serevr that do nightly maintenance operations: check for corrupted tables, reindex and pack all tables etc.

>I have a table that has around 66% deleted records, and is accessed with SET DELETED ON.
>
>Users complain it is slow when accessing it.
>
>Would it be wise to add DELETED() Tag?
>
>Thanks
>Kev
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform