Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Disabling indexes for a moment
Message
 
 
À
13/08/2001 13:38:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00543126
Message ID:
00543144
Vues:
20
>Nadya,
>
>Are you sure it's the indexes that delay the append ?
>I would rather look into (1) the Record Validation rule and maybe (2) any triggers that are fired.
>
>You can temporarily disable record validation and triggers if you are comfortable that the data you are appending is ok.
>
>Personally, I would not disable any. Just in case.
>
>hth
>Gregory

That's true too. Table has Record validation and field validations. I'm not sure, how to disable them in APPEND FROM (just checked Help, if I missed NOVALIDATE clause, but unfortunately, there is no such clause in this command).

>-----------------------------
>>Hi everybody,
>>
>>I have a file with lots of indexes. I have to append couple of files into this file. I'm using APPEND FROM command to append. This operation is very slow due to the indexes. Is there a simple way of "disabling" indexes for a moment?
>>
>>I'm thinking about renaming cdx temporary, do append operation, rename it back and do reindex. But it sounds like klugy approach, besides, file will give an error in attempt to open it.
>>
>>Can you suggest something here? It's for VFP6.0.
>>
>>Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform