>Nadya,
>
>I guess this table is involved in Referential Integrity rules, which causes a lot of code execution for each record updated.
>
>You may have to find out which database triggers and rules are fired and which one you could leave out.
>
>Further, I would not reccommend using tablebuffering because each record has to be buffered into memory, causing your computer to run out of resources with such large amount of records.
Walter,
That's a good point. I probably would use record buffering, if number of records greater than 10000...
Actually, this table is a result of SQL, so it doesn't have any triggres...
Thanks again for your help.
>>Hi everybody,
>>
>>I have more than 1 mln. records in a table, which is table buffered. I updated 700000 records. Now I issued TableUpdate. It took already ~10 min. and VFP screen is blank (freezing). Is there a way to speed up this process?
>>
>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog