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.