Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET EXCLUSIVE OFF - slow TABLEUPDATE
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
SET EXCLUSIVE OFF - slow TABLEUPDATE
Miscellaneous
Thread ID:
00178887
Message ID:
00178887
Views:
50
I have a legacy app originally used on one machine in which I only recently put SET EXCLUSIVE ON. TABLEUPDATE and TABLEREVERT are a whole lot slower now, taking as much as several seconds. The main table has only 6500 records, and there is a parameterized view selecting a few records from another table of 5700 records.

I suppose that SHARED use of tables requires some overhead, but this seems excessive.
Next
Reply
Map
View

Click here to load this message in the networking platform