>>>With VFP7 it takes less than a second to update the table.
>>>With VFP8 it takes more than 3 minutes
>>Have you checked out SET TABLEVALIDATE? This might be what's slowing you down.
>No. What the SET TABLEVALIDATE has to do with the TABLEUPDATE ?

If TABLEVALIDATE is set to 2 or 3, it validates the record count on every insert. I'm wondering if that could be your problem here.