>>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.
>
>What does the update code look like?

        FOR i=1 TO THISFORM.numopen
           SELECT (THISFORM.laDE[i,1])
           IF CURSORGETPROP("Buffering") # 1
     *!*              =TABLEUPDATE(.T.,.T.)
     * -- DG/NSL 4/19/00 Added changes to handle WG multiuser issues
               IF !TABLEUPDATE(2,.F.,ALIAS(),latuerror)
                     *--- Walk through array of failed records and determine if there was a field collision.
                     FOR i=1 TO ALEN(latuerror,1)
                          GO (latuerror[i])
     *                     IF Thisform.fieldcollision()          && Check if there was a field collision for this failed update
                               Thisform.updatefaillog()     && Log records which failed to UPDATE due to conflict.
     *                     ELSE
                               *--- No field collision, update this record by merging the two records.
                               *--- NOTE: Merging will mean I take the 
     *                     ENDIF
                     ENDFOR
                     RELEASE latuerror
                ENDIF
     * -- End of 4/19/00 changes
           ENDIF
        ENDFOR