Aleksey,

Thanks for the advice. I applied the changes and it worked like a charm. Can you provide a brief explanation on why I had to make this adjustment?

Thanks,

David

>Hi David,
>
>Make sure the base tables for the view are not opened in table buffering mode. I mean, there must be no work area where base tables are USEd in table buffering mode. If this is not the case then I believe that the perf issue is not related to TABLEUPDATE.
>
>BTW, could you post the code that demonstrates the issue?
>
>Thanks,
>Aleksey.
>
>>Has anyone notice a performance issue with the Tableupdate function in FoxPro 8?
>>
>>I checked all the normal stuff: indexes, primary key, update fields, etc.
>>
>>I have been converting a large application from Visual FoxPro 7 to Visual FoxPro 8. The application uses local views exclusively to perform record updates. I discovered yesterday an issue with the TABLEUPDATE function between FoxPro version 7 and 8. The TABLEUPDATE function performs noticeably slower in FoxPro 8. I have read many postings on the universal thread concerning this issue. I have been able to work around most of the slowness issues based on my readings, however, the workarounds have not worked in all cases. The update process on an 8 record local view should not take tens of seconds. It should take milliseconds to update the local views parent table especially on a 3.0 GHz processor with 768MB of RAM.