Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter very slow
Message
From
12/08/1997 18:35:30
 
 
To
12/08/1997 11:30:39
Larry Long
ProgRes (Programming Resources)
Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00044161
Message ID:
00044359
Views:
30
What do you mean with the point 2)?

Vlad

>Whenever you set filter you need to...
>1)Ensure that you have an index on the field you are filtering
>2)set order to 0, otherwise you essentially get 2 filters fighting each other
>3)if you have set deleted on, you should have an index on deleted(), something like "INDEX ON DELETED() TAG ISDELETED"
>
>In most cases it is better to use an SQL Cursor for most filters.
>
>Hope this helps //:^)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform