>Hi -
>ANy suggestions on increasing peformance when applying a filter to a large table. Its seems to be taking forever.
>Unfortunately we can can't put the filter expression into the index.
>
>Any ideas please
>
>Thanks,
>
>Larry
If you filter a small subset of data from a large file, the filter will be slow, especially if you combine it with a grid.
Use a view instead. The view is like an updatable query, i.e., TableUpdate() will update the tables the view is based on.
Hilmar.
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)