Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Hi Bob
In fact, SET KEY should be faster than SET FILTER in most cases. SET FILTER requires VFP to examine the available indexes and produce "bitmaps". This process takes time.
>The Online Help explains it very well but I would summarize the difference in 'Set Key' command has to have a tag/order set on the expression, 'Set Filter' doesn't. You will find that 'Set Filter to' expression is faster when the expression is optimized.
>
>I think most developers prefer for 'Set Filter' command because of its flexibility.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only