>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.
Another thing you should check is antivirus software. You can turn it off temporarily, and see whether this improves performance.
>
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)