Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter slow my operation
Message
From
26/07/2004 10:21:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
26/07/2004 04:33:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00927837
Message ID:
00927913
Views:
23
>hi,
>thank you,
>it works,
>but i think it take same time.
>
>regards.

If your filter is:
SET FILTER TO char3=thisform.combo1.value
Then I assume that char3 is a field in the table.

In this case, you should have an index with the expression char3. This will make both a filter and a query faster, if they use this field for a condition.

For more details, search the help file for "Rushmore Optimization".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform