Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
P-view speed
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00179841
Message ID:
00180128
Views:
25
Phillip,

If you use SET DELETED ON in your app, you MUST have an index with DELETED() as the expression so that Rushmore can fully optimize. Otherwise FoxPro must read the entire table checking the first byte of each record.

>I'm guessing that indexing on DELETED() is your problem. Records marked for deletion are ignored by commands, but NOT by the index (and therefore RUSHMORE). Just for laughs, try getting rid of the DELETED tags and try it again.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform