>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