Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>You said...
>It reminds me of people who need to add a million records in one batch, who drop indexes or something, to avoid a million REINDEXes.
>
>I may be mistaken, but your idea seems resonable. You could make mass deletions in the three child tables without indicies if you deliberately track the group field in each child table. Yes, this would denormalize your data; it would require some slight modification to your data entry system to update the group fields in each child table. This minor concession would free your network of a lot of traffic and simplify your work to just four independent deletions and four independent reindexes (uh...reindexings???).
>
>Please help me learn from you. What is this RI? I cannot find it on the help index. I looked at all the R's in case it might be some interface like reindex interface. Nothing comes close. Thanks for your help.
>
>(Also I respectfully submit that the plural of index is indicies. I feel it is a lost cause, but I keep trying. I hope this is in good taste and does not violate our UT rules.)
Since this mass delete will only be carried out every few months to make a subset of the database, I plan to drop the relations, delete from the individual tables separately, then restore them.
RI is Referential Integrity.
I have seen manuals for other software use "indexes" as the plural for "index". That might even be correct. "Indices" (not "indicies") makes me think of the individual index values. I think of an "index" as a collection of "indices" which are not individually important to VFP programmers.
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