Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance issue
Message
From
17/11/1996 23:04:01
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00012506
Message ID:
00012575
Views:
36
>Please provide more details on the performance problem. I'd hate to rework my apps that use SET DELETED ON, and 10,000+ record tables are common.

Easy to test.

Use FoxPro Windows.
1. Create a table having 100000+ records
2. Create at least this tag INDEX ON DELETED() TAG DELETE
3. SET DELETE ON
4. BROWSE or SELECT * FROM table WHERE yourtagvalue INTO CURSOR TEMP
You're gonna get the result right away.

Now, do the same in Visual FoxPro 3 or 5. You'll end up with a wait time because of the SET DELETE ON which should not be use anymore.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform