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
Miscellaneous
Thread ID:
00178887
Message ID:
00178899
Views:
26
The header of the message and the body of the message seem to be in contradiction. Did you change SET EXCLUSIVE to ON or OFF?

It's normal for TableUpdate() and TableRevert() to take longer with SET EXCLUSIVE OFF, because they have to check that the record/table is not in use before commiting the change.

Be careful with SET EXCLUSIVE ON, not only no other user can use the table, but you cannot open another form within the same application that will use the same table (with private datasession).

HTH

>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform