Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which is optimizable
Message
From
25/08/1997 08:29:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Which is optimizable
Miscellaneous
Thread ID:
00046652
Message ID:
00046652
Views:
71
In this VPF 5.0 app, the client does not delete records (legal reasons). In each table is a logincal filed called SUPPRESS. If it is TRUE, the record is suppressed (should not be included in SQL). I use SQL's to populate grids in forms, so I need FAST operation. There is in index on Suppress In the SQL, if I add " WHERE !SUPPRESS", will it be Rushmore optimized? I once heard that .not. clauses are not optimizable. Or should I change the meaning of the SUPPRESS field, so that a TRUE in SUPPRESS means include, so the WHERE clause can be "WHERER SUPPRESS". Is this optimizable?
Next
Reply
Map
View

Click here to load this message in the networking platform