Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate()
Message
From
18/09/2003 11:49:40
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00830344
Message ID:
00830349
Views:
23
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform